PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Speakers
Selena Deckelmann
Schedule
Day Talks - second day - 2009-05-22
Room DMS 1110
Start time 11:30
Duration 01:00
Info
ID 184
Event type Lecture
Track Version 8.4
Language used for presentation English

VACUUM Strategy

Autovacuum, FSM, Visibility Map

VACUUM is a an important topic for new and seasoned users of Postgres. This talk will focus on changes in Postgres from version 8.0 on, how to bast take advantage of configuration parameters related to VACUUM, autovacuum, the updated Free Space Map in 8.4, and the brand new Visibility Map.

VACUUM is a an important topic for new and seasoned users of Postgres. This talk will focus on changes in Postgres from version 8.0 on, how to bast take advantage of configuration parameters related to VACUUM, autovacuum, the updated Free Space Map in 8.4, and the brand new Visibility Map.

This talk will cover some internals, but will focus on practical effects of changing parameters, and how to best tune VACUUM related parameters in Postgres for better performance.