Questions tagged [autovacuum]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
3k views

When is Postgres autovacuum executed

I am using an older version of Postgres (8.4.20). I know that the autovacuum process is executed frequently to free disk space of queries that deleted or updated data in tables. I have a database ...
5
votes
1answer
496 views

Tiny table causes extreme performance degradation, fixed by forced VACUUM. Why?

I use PostgreSQL 9.6. I have a query that joins 17 tables, 9 of those having several million rows. The query was running fine but its performance degraded rapidly this week. EXPLAIN's output didn't ...
2
votes
0answers
539 views

Autovacuum gets exclusive lock and replayed in the slave and lead to system fault

I had trouble in my environment which is related to autovacuum and now I think I understand how this occurs. However, this is kind of a rare issue and so I want to get some advice regarding this issue....
6
votes
1answer
2k views

Debug query on big table that is sometimes slow

I have a web API that is backed by a Postgres database, and the performance is generally very good. I monitor the performance of both the database and the application as a whole. Most of my queries (...
3
votes
1answer
436 views

Do the different “types” of autovacuum have different performance characteristics?

In monitoring the autovacuum activity on my database, I've noticed that autovacuums tagged with (to prevent wraparound) seem to take longer than "regular" autovacuums. That got me started trying to ...