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 new book by 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.
-
Hardware Benchmarking
Make sure that your investment in Database server hardware is sound, and represents an appropriate trade-off for your particular application.
-
Performance Forecast
2ndQuadrant can extrapolate how performance of your database is likely to degrade over time.
-
Performance Tuning
2ndQuadrant work to popularize PostgreSQL as a high-performance database platform.
-
SQL Tuning
Take the guesswork out of debugging slow performing queries.
