Date: Tue, 14 Feb 2017 11:52:55 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: walpino@gmail.com
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: (auto) vacuum mysterious
Message-ID: <20170214145255.7v3x64l22h4sylck@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <58a2d8c3.8a6d1c0a.dd92a.e25e@mx.google.com>
User-Agent: NeoMutt/20170113 (1.7.2)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin