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
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.
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