Presented by:

Bccf827b9ac8e85df67d91d91c555f34

Jessica Sharp

EnterpriseDB
No video of the event yet, sorry!

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: 53)