summary: database has 291 empty pg_toast_temp schemas. severity: head-scratcher version: 9.0.7 platform: RHEL6
description: * medium-large production database (300GB) * does data collection and analytics * lately has been having chronic lock-blocking issues * does many, daily batch jobs which involve the creation of many temp tables. Today, while investigating the lock-blocking issues, I noticed that the db has pg_toast_temp_1 through 291. All of these schema are completely empty: breakpad=# select schemaname, relname from pg_stat_all_tables where schemaname LIKE 'pg_toast_temp_%'; schemaname | relname ------------+--------- ... so, apparently we still have an issue with cleaning up pg_toast_temp schema? -- 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
