Greg Stark escribió: > Can autovacuum just set a flag on the orphaned temp table's pg_class > record indicating it's been determined to be an orphan? Then other tools > could easily list orphaned tables and offer to delete them.
Add a new column to pg_class just for orphan tables? Sure sounds overkill. Maybe a bit in the pgstats entry for the table ...? It still seems like useless bloat to me. I wonder if we can find out whether a temp table is orphaned by some other means (a query against catalogs + list of active backends? It still needs to know whether the table was created by this backend or a previous one.) -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
