From: =?UTF-8?B?T25kxZllaiBTdsSbdGzDrWs=?= <osvetlik@flexibee.eu>
Subject: Re: Autovacuum of pg_shdepend
To: pgsql-admin@postgresql.org
References: <20160504152518.GA102195@alvherre.pgsql>
Message-ID: <572A48D3.9040906@flexibee.eu>
Date: Wed, 4 May 2016 21:09:07 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.7.1
MIME-Version: 1.0
In-Reply-To: <20160504152518.GA102195@alvherre.pgsql>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Dne 4.5.2016 v 17:25 Alvaro Herrera napsal(a):
> Ondřej Světlík wrote:
>> Hello,
>>
>> 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.
>
> Ooh, interesting bug.
>
> As a workaround I suggest connecting to all of your databases except one
> and disabling autovacuum for pg_shdepend.  Then the table will be
> processed in the one database where you left it enabled, and the other
> workers will take care of the rest of the tables.
>
> I'll think about a real fix.
>


Thank you, Alvaro,

we have already tried this, but we are not permitted to alter system 
tables. Changing allow_system_table_mods doesn't seem safe enough, is 
there another way to achieve this?

Oh, I forgot to mention this is 9.4.7.

Thanks,

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