Blog Post

Azure Database for PostgreSQL Blog
11 MIN READ

Debugging Postgres autovacuum problems: 13 tips

samay_sharma's avatar
samay_sharma
Icon for Microsoft rankMicrosoft
Jul 28, 2022
If you’ve been running PostgreSQL for a while, you’ve heard about autovacuum. Yes, autovacuum, the thing which everybody asks you not to turn off, which is supposed to keep your database clean and re...
Updated Jul 28, 2022
Version 1.0
Open Source
Performance
Performance Issues
Postgres
PostgreSQL
Kibo_Jay_Zmudka's avatar
Kibo_Jay_Zmudka
Copper Contributor
Jul 29, 2022

Thank-you so much Samay! This helped me solve a stubborn problem we were having with a postgres query. The catalog files were bloated and were constantly being autovacuumed. Turns out we had a replication slot sitting there that was no longer being used.