endorsedCompleted

PostgreSQL Tuning and Monitoring for Ranktracker

Services Covered:

Big Data Analytics and Business Intelligence • Custom Software Development

Industry

Advertising & Marketing

Duration

10 months

Budget

10K - 49K

Start Date

1 December 2021

Team Size

6-10 Employees

Engagement Model

Nearshore

Project Capability Score (PCS)

77/100

Good

Project Capability Score (PCS) estimates how capable DATAFOREST is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Ranktracker

Poland

Project Summary

DATAFOREST tuned PostgreSQL configuration and improved the master/slave reliability for a rank-tracking SaaS client. They identified bottlenecks (idle connections, high CPU waits, excessive locks), implemented Prometheus and Grafana monitoring for real-time analysis, and delivered the work on schedule while maintaining clear communication.

Key Challenges

Tune PostgreSQL configuration and improve the reliability of the master/slave setup

Project Deliverables

Tuned PostgreSQL configuration file
Improved the reliability of the master/slave setup
Implemented Prometheus monitoring and Grafana master/slave dashboards

Project Solution

DATAFOREST assigned a team (6-10 employees) including experienced database engineers to fine-tune the client's PostgreSQL configuration and improve master/slave reliability. They diagnosed issues such as idle connections, high CPU waits due to kernel IO, excessive locks, long transactions, IOPS bottlenecks, and replica sync delays, and proposed and implemented targeted solutions including monitoring systems.

Project Outcome

Quickly identified configuration weaknesses causing replication lag
Implemented Prometheus and Grafana monitoring for real-time master and slave dashboards
Improved database reliability and delivered the project on schedule

Platforms

Embedded System

Tech Stack

PostgreSQL

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“DATAFOREST successfully identified issues with the client's setup and proposed effective solutions, demonstrating vast expertise and professionalism. Their PostgreSQL knowledge was outstanding, as was their attention to detail and valuable insights. Moreover, they were efficient and communicative.”
Felix Rose-Collins
CEO
Date: 06/15/2023