Re: pg_toast_temp & pg_temp schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_toast_temp & pg_temp schemas
Date
Msg-id 6253.1281648310@sss.pgh.pa.us
Whole thread Raw
In response to pg_toast_temp & pg_temp schemas  (akp geek <akpgeek@gmail.com>)
List pgsql-general
akp geek <akpgeek@gmail.com> writes:
>           In the postgres db we have, I see there are many pg_toast_temp and
> pg_temp schemas are getting created.

This is expected if you're using temp tables.  That's where they live.

> Is it ok to drop those schemas ? Is
> there a way to prevent them being created?

No, and no (other than not using temp tables).

            regards, tom lane

pgsql-general by date:

Previous
From: akp geek
Date:
Subject: pg_toast_temp & pg_temp schemas
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: Very bad plan when using VIEW and IN (SELECT...*)