Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.
Дата
Msg-id 17c5b15451fac2ace7a815d1d2c8f86e1d232802.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.  (Avinash Kumar <avinash.vallarapu@gmail.com>)
Ответы Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.  (Avinash Kumar <avinash.vallarapu@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Thu, 2020-05-07 at 18:17 -0300, Avinash Kumar wrote:
> > The nice thing about separate databases is that it is easy to scale
> > horizontally.
> 
> Agreed. But, how about autovacuum ? Workers shift from DB to DB and 500 clusters
> means you may have to have a lot of manual vacuuming in place as well.

Just set "autovacuum_max_workers" higher.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNERQuery )
Следующее
От: Avinash Kumar
Дата:
Сообщение: Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.