Mark Rostron <mrostron@xxxxxxx> writes: > We do a lot of work with temp tables here, and over time a lot of pg_temp_[n] schemas have appeared. > Similarly, we notice build-up of pg_toast_[n] schemas. This is expected. There'll be one for each backend slot that's ever used any temp tables. > Is it ok to drop these if they contain no tables? It's risky: you have the race condition that some backend might be just starting to use a temp schema when you decide to blow away the schema. It's also pretty pointless, since the schema will just come back again next time it's needed. I'd say just ignore the temp schemas. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
