Chapter 8. Performance Tuning

Measuring Performance

Tuning a PostgreSQL database is done for many reasons and can be done in many ways. On the one hand, users and developers want to see their applications run faster; on the other hand, performance is a good argument for selling a product to a customer. One way to achieve higher performance is to invest in the latest hardware, such as faster processors, more memory, or faster I/O systems. This is a good solution, but higher performance can also be reached by tuning and focusing on the intelligent design of your application. It is up to you to decide which way to go if you need higher performance. We will describe some ways to tune your PostgreSQL database and see how much performance we can gain. ...

Get PostgreSQL Developer's Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.