Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_temp_N temp schema buildup

pg_temp_N temp schema buildup

From
Jerry Sievers
Date:
Hello.

I'm running postgres 7.4.1 and notice an accumulation of temp schemas
named pg_temp_1, pg_temp_2... etc.

These schemas are empty and I have manually removed them from time to
time.

What procedure is leaving these behind and is there a way for me to
have them cleaned up automatically after use?

Thanks.

--
-------------------------------------------------------------------------------
Jerry Sievers   305 854-3001 (home)     WWW ECommerce Consultant
                305 321-1144 (mobile    http://www.JerrySievers.com/

Re: pg_temp_N temp schema buildup

From
Tom Lane
Date:
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

Re: pg_temp_N temp schema buildup

From
Mike G
Date:
I believe they are created when either a function / program creates a temporary table.

On Wed, May 19, 2004 at 08:32:06AM -0400, Jerry Sievers wrote:
> Hello.
>
> I'm running postgres 7.4.1 and notice an accumulation of temp schemas
> named pg_temp_1, pg_temp_2... etc.
>
> These schemas are empty and I have manually removed them from time to
> time.
>
> What procedure is leaving these behind and is there a way for me to
> have them cleaned up automatically after use?
>
> Thanks.
>
> --
> -------------------------------------------------------------------------------
> Jerry Sievers   305 854-3001 (home)     WWW ECommerce Consultant
>                 305 321-1144 (mobile    http://www.JerrySievers.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster