Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_temp_N temp schema buildup - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_temp_N temp schema buildup
Date
Msg-id 24356.1085119897@sss.pgh.pa.us
Whole thread Raw
In response to pg_temp_N temp schema buildup  (Jerry Sievers <jerry@jerrysievers.com>)
List pgsql-general
Tree view 
Jerry Sievers <jerry@jerrysievers.com> writes:
> I'm running postgres 7.4.1 and notice an accumulation of temp schemas
> named pg_temp_1, pg_temp_2... etc.

That's intentional.  Removing them just causes extra work to add them
again later (not to mention possibly crashing any backend that is
actively using one you remove).

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index not being used properly
Next
From: Mike Nolan
Date:
Subject: Re: Data change logs