pg_temp_N temp schema buildup
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/
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
I believe they are created when either a function / program creates a temporary table.
Show quoted text
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