"Joshua D. Drake" <j...@commandprompt.com> writes: > While it is obvious what is happening in $SUBJECT as well as reasonably > obvious why it can happen. What isn't obvious is what to do about it. It > seems we log in as a super user and drop the temp tables.
You don't need to do anything --- the table will go away the next time a session makes use of that pg_stat_temp schema. > However, I would think if we know that it is orphaned that autovacuum > should just clean those up? That seems to me to be outside the charter of autovacuum, particularly since orphan tables might be of interest for forensic reasons. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers