18.1. Tuning PostgreSQL

PostgreSQL is designed to meet the needs of a variety of different applications and requests. Depending on what you are using the database for and on which hardware you want to run, the best settings for PostgreSQL might vary significantly.

PostgreSQL offers a great deal of flexibility in the way it can be configured. You can set and modify many runtime parameters to define the behavior of the database. In addition, tuning increases the speed of your system.

In this chapter you will be guided through the fundamentals of tuning PostgreSQL. You will see what you can do to speed up your database and how PostgreSQL works internally.

When tuning databases, some important things have to be taken into consideration. In this chapter, ...

Get PHP and PostgreSQL: Advanced Web Programming 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.