Autovacuum of pg_shdepend

Поиск
Список
Период
Сортировка
От Ondřej Světlík
Тема Autovacuum of pg_shdepend
Дата
Msg-id 572A1072.5080308@flexibee.eu
обсуждение исходный текст
Ответы Re: Autovacuum of pg_shdepend  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: Autovacuum of pg_shdepend  (Victor Yegorov <vyegorov@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Inspect values of prepared statements
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Autovacuum of pg_shdepend