Do stuck replication slots prevent autovacuum of running entirely?

From: Marcelo Fernandes <marcefern7(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Do stuck replication slots prevent autovacuum of running entirely?
Date: 2025-05-21 04:34:22
Message-ID: CAM2F1VP11Pv7QcVjTzM_X_uNDvd_qPYvGAnneU-Fn8hW2umFPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

I am trying to understand if a stuck replication slot would be sufficient to
stop an autovacuum of even starting.

Couldn't the autovacuum process start, but fail to remove dead tuples that
are still necessary by the replication slot? Why would it prevent autovacuum
of even starting instead?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2025-05-21 06:05:19 Re: Do stuck replication slots prevent autovacuum of running entirely?
Previous Message Tessa Niebel 2025-05-20 18:06:33 Postgres query tool not working when I right click