cleanup of pg_temp schemas

From: "Marcel Gsteiger" <Marcel(dot)Gsteiger(at)milprog(dot)ch>
To: <pgsql-general(at)postgresql(dot)org>
Subject: cleanup of pg_temp schemas
Date: 2005-01-26 13:28:46
Message-ID: s1f7a939.021@milprog1.milprog.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 should this be done preferably?

Any help would very much be appreciated.

Regards
--Marcel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew L. Gould 2005-01-26 13:35:53 Re: [ODBC] ODBC (win32) X PostgreSQL(Linux)
Previous Message icaro 2005-01-26 13:21:48 Case Insensitive & Accent Insensitive