Re: Why lots of temp schemas are being created - Mailing list pgsql-general

From Tom Lane
Subject Re: Why lots of temp schemas are being created
Date
Msg-id 13976.1265243064@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why lots of temp schemas are being created  (Walter Coole <WCoole@aperiogroup.com>)
List pgsql-general
Walter Coole <WCoole@aperiogroup.com> writes:
> I've gotten a lot of similar schemas, like:
> CREATE SCHEMA pg_toast_temp_1
>   AUTHORIZATION postgres;

These schemas are automatically created to hold temporary tables.  There
is not a lot of point in removing them, because they'll just reappear
next time you have a lot of sessions creating temp tables.

You might want to pester the pgAdmin folk to add an option to ignore
them in pgAdmin's displays.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Why lots of temp schemas are being created
Next
From: Alvaro Herrera
Date:
Subject: Re: Why lots of temp schemas are being created