Postgres Pro
Downloads
Home   >   mailing lists

cleanup of pg_temp schemas - Mailing list pgsql-general

From Marcel Gsteiger
Subject cleanup of pg_temp schemas
Date
Msg-id s1f7a939.021@milprog1.milprog.ch
Whole thread Raw
Responses Re: cleanup of pg_temp schemas
Re: cleanup of pg_temp schemas
List pgsql-general
Tree view 
Hi all,

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. 

Who takes care for removing these schemas? Can I safely ignore them, or do I have to clean them up periodically? How
shouldthis be done preferably? 

Any help would very much be appreciated.

Regards
--Marcel

pgsql-general by date:

Previous
From: "icaro"
Date:
Subject: Case Insensitive & Accent Insensitive
Next
From: "Andrew L. Gould"
Date:
Subject: Re: [ODBC] ODBC (win32) X PostgreSQL(Linux)