Re: Do stuck replication slots prevent autovacuum of running entirely?

2025-05-20 Thread Laurenz Albe
On Wed, 2025-05-21 at 16:34 +1200, Marcelo Fernandes wrote: > 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

Do stuck replication slots prevent autovacuum of running entirely?

2025-05-20 Thread Marcelo Fernandes
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 inst

Re: Logical replication, need to reclaim big disk space

2025-05-20 Thread Achilleas Mantzios
Στις 20/5/25 12:17, ο/η Moreno Andreo έγραψε: On 19/05/25 20:49, Achilleas Mantzios wrote: On 19/5/25 17:38, Moreno Andreo wrote: On 19/05/25 14:41, Achilleas Mantzios wrote: On 5/19/25 09:14, Moreno Andreo wrote: On 16/05/25 21:33, Achilleas Mantzios wrote: On 16/5/25 18:45, Moren

Re: Logical replication, need to reclaim big disk space

2025-05-20 Thread Moreno Andreo
On 20/05/25 12:58, Achilleas Mantzios wrote: Στις 20/5/25 12:17, ο/η Moreno Andreo έγραψε: On 19/05/25 20:49, Achilleas Mantzios wrote: On 19/5/25 17:38, Moreno Andreo wrote: On 19/05/25 14:41, Achilleas Mantzios wrote: On 5/19/25 09:14, Moreno Andreo wrote: On 16/05/25 21:33, A

Re: Logical replication, need to reclaim big disk space

2025-05-20 Thread Moreno Andreo
On 19/05/25 20:49, Achilleas Mantzios wrote: On 19/5/25 17:38, Moreno Andreo wrote: On 19/05/25 14:41, Achilleas Mantzios wrote: On 5/19/25 09:14, Moreno Andreo wrote: On 16/05/25 21:33, Achilleas Mantzios wrote: On 16/5/25 18:45, Moreno Andreo wrote: Hi,     we are moving our old