PostgreSQL Tuning

The path to building each high-performance PostgreSQL system has its own unique challenges.

There are, however, plenty of aspects to each deployment with common elements, patterns that emerge once you've watched dozens of companies build similar systems. Some of this knowledge is public. Internet guides such as Tuning Your PostgreSQL Server provide a jump start on basic server configuration. Automated tuning wizard programs such as pgtune make that even easier.

The book by former US-based 2ndQuadrant principal consultant Gregory Smith, “PostgreSQL 9 High Performance” supplements the database documentation with hundreds of pages of tips in this area, spanning the gamut of concerns that any PostgreSQL DBA is likely to have. 

We can help you to deliver outstanding performance to your customers, while avoiding pitfalls that cause loss of durability or data integrity.

Stay in touch with us

Subscribe to our quarterly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.