Autovacuum of pg_shdepend - Mailing list pgsql-admin

From Ondřej Světlík
Subject Autovacuum of pg_shdepend
Date
Msg-id 572A1072.5080308@flexibee.eu
Whole thread Raw
Responses Re: Autovacuum of pg_shdepend  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Autovacuum of pg_shdepend  (Victor Yegorov <vyegorov@gmail.com>)
List 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


pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Inspect values of prepared statements
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum of pg_shdepend