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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.
Дата
Msg-id CAMkU=1w_6QNA6F7=D_bX=GD-zvZOBoEYC6WZrMxeUU2JNmK_qw@mail.gmail.com
обсуждение исходный текст
Ответ на pg_attribute, pg_class, pg_depend grow huge in count and size withmultiple tenants.  (samhitha g <samhithagarudadri@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Thu, May 7, 2020 at 4:05 PM samhitha g <samhithagarudadri@gmail.com> wrote:
Hi experts,

Our application serves multiple tenants. Each tenant has the schema with a few hundreds of tables and few functions.
We have 2000 clients so we have to create 2000 schemas in a single database.

While doing this, i observed that the catalog tables pg_attribute, pg_class, pg_depend grow huge in count and size.

Please attach numbers to "huge".  We don't know what "huge" means to you.

"2000  * a few hundred" tables is certainly getting to the point where it makes sense to be concerned.  But my concern would be more about backup and recovery, version upgrades, pg_dump, etc. not about daily operations.

Cheers,

Jeff

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

Предыдущее
От: MichaelDBA
Дата:
Сообщение: Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: pg_attribute, pg_class, pg_depend grow huge in count and sizewith multiple tenants.