Time: 17:20 - 18:10
Room: Baltic II+III
PostgreSQL offers different kinds of buffers used for caching and most of them are configurable. But how should they be configured?
How big should my shared_buffers be? Do I need to do anything special if I use a lot of temporary tables? Will a sequential scan on a huge table ruin my cache?
All these questions will be answered, and we will also talk about considerations for configuring checkpoints and the background writer and how that affects the choice of buffer size.
The following slides have been made available for this session: