Re: (auto) vacuum mysterious

walpino(at)gmail(dot)com wrote:
> Hi There
>
> My Name is Martin
> And we are running PostgreSQL 9.5.3
>
> We are doing a lot of deletes updates and Inserts on some tables
>
> Until now we didn’t Encounter so much Problems with the vacuumizer but in the last view days we have the fact the vacuum cannot remove dead rows anymore
>
> I know it is the case when there are other Long running Transactions running but this isn’t the case

Maybe you have an inactive replication slot. See
select * from pg_replication_slots;
and consider dropping those that are unused.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services