Re: Huge number of pg_temp and pg_toast_temp schemas

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: Huge number of pg_temp and pg_toast_temp schemas
Дата
Msg-id 276C10EF1CEA4FF48A08418C222F7C61@dell2
обсуждение исходный текст
Ответ на Re: Huge number of pg_temp and pg_toast_temp schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Huge number of pg_temp and pg_toast_temp schemas
Список pgsql-general
Hi!

Thank you.

>This is an unsurprising state, if you routinely have a hundred-plus
>connections that sometimes create temp tables.  Each such session
>needs schemas to keep its temp tables in.  The temp tables are
>deleted at session exit, but we don't bother to remove the schema
>entries, figuring that they'll probably be needed again later, and
>a couple of rows in pg_namespace is negligible overhead anyway.

How to hide temp schemas from pgAdmin 4 tree?
For such large number of temporary schemas  pgAdmin schema tree view becomes polluted and makes database management
difficult.
I turned most of Nodes options in PgAdmin options off but pgadmin still shows them. It shows also pg_toast schema.

Andrus.

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Huge number of pg_temp and pg_toast_temp schemas
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Huge number of pg_temp and pg_toast_temp schemas