From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: walpino@gmail.com
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: (auto) vacuum mysterious
Date: Tue, 14 Feb 2017 11:52:55 -0300
Message-ID: <20170214145255.7v3x64l22h4sylck@alvherre.pgsql> (raw)
In-Reply-To: <58a2d8c3.8a6d1c0a.dd92a.e25e@mx.google.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, walpino@gmail.com
Subject: Re: (auto) vacuum mysterious
In-Reply-To: <20170214145255.7v3x64l22h4sylck@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox