|
|
EVENT DETAILS |
Do you support the PostgreSQL database behind a demanding application? Do your users have queries that mysteriously get progressively slower over time & then run normally again without explanation? Is AutoVacuum working on a particular table(s) almost all the time? This presentation offers guidance on identifying good practices around monitoring AutoVacuum, how to approach tuning, & how to avoid the most common pitfalls I see during tuning exercises as a consultant in the field.
In this presentation you will learn:
- High level of what Autovacuum is doing & why.
- How to monitor & analyze Autovacuum performance.
- How to identify the most common Autovacuum based database operation interferences.
- High level guidance on putting the above points together to improve Autovacuum efficiency.
|
|
|
|
|
|