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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match