[GENERAL] cleanup of pg_temp schemas

2005-01-26 Thread Marcel Gsteiger
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

Re: [GENERAL] cleanup of pg_temp schemas

2005-01-26 Thread Tom Lane
Marcel Gsteiger [EMAIL PROTECTED] 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.

Re: [GENERAL] cleanup of pg_temp schemas

2005-01-26 Thread Martijn van Oosterhout
On Wed, Jan 26, 2005 at 02:28:46PM +0100, Marcel Gsteiger wrote: 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. In general