akp geek <akpgeek@xxxxxxxxx> writes: > In the postgres db we have, I see there are many pg_toast_temp and > pg_temp schemas are getting created. This is expected if you're using temp tables. That's where they live. > Is it ok to drop those schemas ? Is > there a way to prevent them being created? No, and no (other than not using temp tables). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general