This site is about a previous instance of this event. For the current event, please see the updated site.

Conference Schedule - PGConf.EU 2017

PostgreSQL Basics: Buffers

Date: 2017-10-25
Time: 17:20 - 18:10
Room: Baltic II+III
Level: Intermediate

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.

Slides

The following slides have been made available for this session:

Speaker

Vik Fearing