Re: Using temp tables - Mailing list pgsql-admin

From Tom Lane
Subject Re: Using temp tables
Date
Msg-id 23461.1058535407@sss.pgh.pa.us
Whole thread Raw
In response to Using temp tables  (Andreas Schmitz <a.schmitz@cityweb.de>)
List pgsql-admin
Andreas Schmitz <a.schmitz@cityweb.de> writes:
> I did a vacuum full and analyze but this pg_temp namespaces are still there.
> Any ideas about that phenomena ?

They're supposed to be there; we recycle the pg_namespace entry across
successive backend sessions.  I see no point in deleting it only to have
to make it again in a later session.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Marvin"
Date:
Subject: UltraSQL problem.
Next
From: "scott.marlowe"
Date:
Subject: Re: Database growth problem