Postgres Pro
Downloads
Home   >   mailing lists

Re: cleanup of pg_temp schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: cleanup of pg_temp schemas
Date
Msg-id 15142.1106754166@sss.pgh.pa.us
Whole thread Raw
In response to cleanup of pg_temp schemas  ("Marcel Gsteiger" <Marcel.Gsteiger@milprog.ch>)
List pgsql-general
Tree view 
"Marcel Gsteiger" <Marcel.Gsteiger@milprog.ch> writes:
> My PostgreSQL app uses temporary tables. After some time, my database shows lots of pg_temp_xxx schemas with no data
inside.I tried to do a vacuum full analyze to get rid of them, but they still persisted. 

Ignore them.

            regards, tom lane

pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: how come I get this error message when I try to connect to Postgresql
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Recursive queries