Autovacuum of pg_shdepend

From: Ondřej Světlík <osvetlik(at)flexibee(dot)eu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Autovacuum of pg_shdepend
Date: 2016-05-04 15:08:34
Message-ID: 572A1072.5080308@flexibee.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

We have two clusters, both have a few thousands of databases. Because of
this problem the autovacuum process can't keep up and the planner uses
old data causing large impact on the performance.

Is there a way to prevent this behaviour, please?

With regards

Ondřej Světlík

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2016-05-04 15:25:18 Re: Autovacuum of pg_shdepend
Previous Message David G. Johnston 2016-05-03 00:13:57 Re: Inspect values of prepared statements