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.