Monitoring autovacuum induced contention

From: Joseph Hammerman <joe(dot)hammerman(at)datadoghq(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Monitoring autovacuum induced contention
Date: 2023-12-06 21:35:05
Message-ID: CAHs7QM95WgOWBdhtjpbg489A77yLqM6MFOi7qw2BPVNqn3qmeg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi admins,

We are working on tuning autovacuum correctly. While the biggest problem we
have and most other OLTP deployments I have seen have is autovacuum
resource starvation, I'd like to be able to reliably determine when we have
turned autovacuum capacity dials too far.

Is there any way to track autovacuum induced query waits?

Thanks,
Joe

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-12-07 03:16:40 Re: Monitoring autovacuum induced contention
Previous Message Holger Jakobs 2023-12-06 18:22:26 Re: Disable autocommit inside dbeaver