The client experienced performance issues with its PostgreSQL database and turned to Pythian for help. Pythian's in-depth health check revealed that the database’s table size was over three terabytes, resulting in heavy indexing, unoptimized maintenance processes, and continuous disk checking.
Pythian recommended several fixes to resolve the database performance issues and rising cloud costs: partitioning the database into smaller tables, reducing the FYI Docs’ AWS instance size, and optimizing the Autovacuum process. Pythian worked with FYI Docs’ team to implement these solutions on the customer’s Australian and UK databases, resulting in improved performance and cost savings.