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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
