Re: Huge number of pg_temp and pg_toast_temp schemas

On 4/10/20 11:06 AM, Andrus wrote:
> 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.

That's something you probably need to ask the pgAdmin folks:

https://www.postgresql.org/list/pgadmin-support/

> 
> Andrus.


-- 
Adrian Klaver
adrian.klaver@aklaver.com