Re: [ADMIN] (auto) vacuum mysterious - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: [ADMIN] (auto) vacuum mysterious
Date
Msg-id 20170214145255.7v3x64l22h4sylck@alvherre.pgsql
Whole thread Raw
In response to [ADMIN] (auto) vacuum mysterious  (<walpino@gmail.com>)
List pgsql-admin
walpino@gmail.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
vacuumcannot 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


pgsql-admin by date:

Previous
From: Feike Steenbergen
Date:
Subject: Re: [ADMIN] Req. for some help with temp tables
Next
From: Thorsten Schöning
Date:
Subject: [ADMIN] Questions regarding PL/Perl