Fabio isn't taking new orders for this project right now. Here are some similar projects to explore.

You will get a PostgreSQL Cluster Tuned for Optimal Performances

Fabio P.
Fabio P.
5.0
Top Rated

Let a pro handle the details

Buy Database Optimization & Design services from Fabio, priced and ready to go.

You will get a PostgreSQL Cluster Tuned for Optimal Performances

Fabio P.
Fabio P.
5.0
Top Rated

Let a pro handle the details

Buy Database Optimization & Design services from Fabio, priced and ready to go.

Project details

It happens frequently that a bad setup or overlooked settings will transform a super powerful setup into a nightmare.
Thanks to years of experience on production environments and on big data, I can provide a complete health checkup of your PostgreSQL cluster and remove bottlenecks, identify slow queries and provide tips to make them faster.
Also I will go through your complete database installation from hardware up to the db instance, passing through the OS, the RAID controller, and the FileSystem.
After the analysis, I will then perform the steps that can be taken to remove such issues and provide to you a list of improvements by-the-book.
Fast database means happy users. Happy users means quicker and higher ROI.

This offer is only valid on Linux installations, on a maximum of 3 servers (1 master and 2 standby). For different setups, please inquire me.
Database Type
PostgreSQL
What's included $1,300 These options are included with the project scope.
$1,300
  • Delivery Time 5 days
  • Number of Revisions 1
5.0
35 reviews
97% Complete
3% Complete
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
Rating breakdown
Availability
4.9
Deadlines
4.9
Skills
5.0
Cooperation
5.0
Quality
4.9
Communication
5.0

SS

Sergii S.
5.00
Sep 12, 2024
60 minute consultation Fabio is highly skilled in Kafka and PostgreSQL architecture and thoroughly understands the underlying principles. He provided a comprehensive overview of the system and highlighted potential issues we might encounter in our project. His explanations were detailed and well-illustrated, perhaps a bit too detailed at times. Overall, I would recommend Fabio as an expert on these topics.

AS

Andrea S.
5.00
Aug 28, 2024
60 minute consultation Good job!

FT

Federico T.
5.00
Aug 5, 2024
60 minute consultation Fabio has been able to provide a lot of valuable information and concrete suggestions in a very limited amount of time. I got great value from the consultation I purchased

JR

Jan R.
5.00
Jul 4, 2024
PostgreSQL optimizations

DP

Dan P.
5.00
Jul 3, 2024
60 minute consultation Fabio's industry experience and technical expertise are truly world class. The findings and review of my technology proposal have not only saved me thousands of dollars but enabled my website to truly fly. The database side of things is always challenging but Fabio was amazing in walking me through challenges as well as providing solutions. Looking forward to working with Fabio again.
Fabio P.

About Fabio

Fabio P.
Senior PostgreSQL DBA | Kafka | MongoDB | UNIX System Engineer
100% Job Success
5.0  (35 reviews)
Amsterdam, Netherlands - 4:25 am local time
PostgreSQL expert with 15+ years of production experience in Unix system engineering and database administration

My specialties are:

- Amazon RDS, (Google) Cloud SQL and Heruku PostgreSQL databases, all around
- On premise by-the-book setup
- Performance tuning on a large multi-TB, serving OLTP or DWH/BI needs
- Slow queries identification and tackling
- Big Data
- Troubleshooting
- Design and implementation of High Availability setups
- Hardware / Containerized / SaaS setups
- Backup, and disaster recovery of Postgres instances
- Training and technical writing regarding databases and system engineering
- Scaling for massive data setups
- Kubernetes and docker deployments on premise or on Azure Kubernetes Service


Also I am an early adopter of Kafka and MongoDB, with 7+ years experience including:

- Replicated setups
- High available setups by design
- Complete Helm deployments on K8s including Grafana boards, and metrics monitoring/alarms using Prometheus and Alertmanager

On request, I can offer a complete service, including installation and configuration of additional tools like Prometheus exporters, Prometheus-Alertmanager-Grafana installation and tuning, alerts configuration and much more, bringing my 20+ years of system administration at the customer's service

Steps for completing your project

After purchasing the project, send requirements so Fabio can start the project.

Delivery time starts when Fabio receives requirements from you.

Fabio works on your project following the steps below.

Revisions may occur after the delivery date.

30 to 60 minutes videocall

During this call you will pass me the know how about the existing instances

Instances tuning

I will tune the instances by the book, running tests wherever it applies

Review the work, release payment, and leave feedback to Fabio.