I am noticing a large number of temp schemas in my database. We use temp tables but it doesn't appear that the schemas get dropped for some reason. This greatly slows down how long it takes pgAdmin to connect because it retrieves thousands of pg_temp_% schemas.
We mainly use "drop on commit" and see that the tables are gone after the transaction is complete. Any ideas why we have so many temp schemas? Is it safe to just drop them all? Jon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
