From: Ondřej Světlík <osvetlik@flexibee.eu>
To: pgsql-admin@postgresql.org
Subject: Re: Autovacuum of pg_shdepend
Date: Wed, 3 Aug 2016 01:02:08 +0200
Message-ID: <f7d6e8ef-5147-e34e-a19d-c4ea6fbaa33f@flexibee.eu> (raw)
In-Reply-To: <572A56B9.1020202@flexibee.eu>
References: <572A1072.5080308@flexibee.eu>
<CAGnEbojHefZpb=ywyJV1JAm5MA1epoOy9h7e0h5=_KSey6cSEQ@mail.gmail.com>
<572A56B9.1020202@flexibee.eu>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Dne 4.5.2016 v 22:08 Ondřej Světlík napsal(a):
> Dne 4.5.2016 v 20:52 Victor Yegorov napsal(a):
>> 2016-05-04 18:08 GMT+03:00 Ondřej Světlík <osvetlik@flexibee.eu
>> <mailto:osvetlik@flexibee.eu>>:
>>
>> we have a strange problem with autovacuum. We have three workers,
>> but usually only one works and two are waiting as they are all
>> trying to process table pg_shdepend which is shared between all
>> databases.
>>
>>
>> I hit the same issue when we've migrated out all large objects (~200Gb
>> total), I've executed `vacuumlo` and then all autovacuums started to
>> process `pg_shdepend`.
>> They've been picking on this table over and over again from different
>> databases, but were stopping on the truncation phase due to other
>> autovacuums were waiting on the same table.
>>
>> I ended up manually vacuuming this table in the database, that was
>> cleaned up, and also in the `postgres` DB. It fixed the case for me.
>> This was on 9.0.23 though.
>>
>> --
>> Victor Y. Yegorov
>
> Thank you very much, we have a working autovacuum on one of our clusters
> again. That's awesome :-).
>
> Ondřej
Hello again,
as this is still not fixed in any released version and the problem
occurred again, let me ask one question. Which form of manual VACUUM is
sufficient to prevent wraparound? Is it VACUUM FREEZE or do I have to
use VACUUM FULL?
Thanks in advance,
Ondřej
--
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: osvetlik@flexibee.eu
Subject: Re: Autovacuum of pg_shdepend
In-Reply-To: <f7d6e8ef-5147-e34e-a19d-c4ea6fbaa33f@flexibee.eu>
* 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