Tuning Autovacuum for best Postgres performance

Learn the most important concepts of why and when Postgres has to vacuum, why that matters, and when it’s best to tune the default settings that control autovacuum scheduling, vacuum overhead, and more.

Ebook Cover Image

In this book you will learn:

  • What is table and index bloat?
  • What are Transaction IDs and freezing?
  • Performance benefits of frequent vacuuming: All-visible pages
  • The anatomy of a vacuum
  • Tuning when autovacuum is scheduled, and how fast its running
  • Reducing the impact of autovacuum during business hours
  • How to avoid blocked vacuums due to long-running transactions

Download this eBook

Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze

Atlassian
DoorDash
Moody's
fuboTv
SeniorLink
Salsify
CounterPath
Ipsy