Do you support the PostgreSQL database behind a demanding application? Do your users have queries that mysteriously get progressively slower over time and 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, and 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 and why.
• How to monitor and 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.

Date:

2021 March 23 13:00 EDT

Duration:

1 h

Room:

Online

Conference:

2021 Postgres Conference Webinars

Language:

Track:

Ops

Difficulty:

Requires Registration:

Yes (Registered: 132)