On 4/26/12 11:22 AM, Tom Lane wrote: > Josh Berkus <j...@agliodbs.com> writes: >> summary: database has 291 empty pg_toast_temp schemas. > > If your max_connections is 300 or more, this isn't surprising in the > least.
Yes, they are. >> ... so, apparently we still have an issue with cleaning up pg_toast_temp >> schema? > > If they are empty, no we don't have a problem with cleaning them up. > The pg_namespace entries are deliberately left there across sessions, > to avoid useless catalog churn. Aha, ok. Should I add a FAQ item about this? Also, have we discussed maybe hiding these schemas from \dn? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
