In this article, I look at how poorly designed sharding systems and replication systems in PostgreSQL affect query performance in high volume situations, and how to ensure data consistency across many servers. I also discuss how excessive vacuuming generates I/O traffic, and how connection pooling …

Fixing Common PostgreSQL Performance Bottlenecks | Percona Community

Aleksandra_Abramova March 27, 2023, 12:00pm 2

Comment by Philip Kumah Jr.:

This was quiet a read But worth the while. Thanks for this

Topic		Replies	Views
Clarification and suggestions on Query analyze and performance PostgreSQL pmm , percona , postgres , postgresql	0	32	February 5, 2025
Percona Community MeetUp for MySQL - Sept 8th, 2021 Training & Events	4	673	September 8, 2021
Community MeetUp for PostgreSQL , Oct. 13th Training & Events	0	658	October 6, 2021
Community MeetUp: "Optimization of PostgreSQL instance", Dec 15th Training & Events	0	616	December 9, 2021
Low performance in queries when we get several connections Percona Server for MySQL 5.7	1	600	June 14, 2020