O'Reilly logo

PostgreSQL Developer's Handbook by Hans-Jürgen Schönig, Ewald Geschwinde

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required