Re: including backend ID in relpath of temp rels - updated patch
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Jaime Casanova <jaime@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2010-08-06T19:00:35Z
Lists: pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes: > This patch only directly addresses the issue of cleaning up the > storage, so there are still the catalog entries to worry about. But > it doesn't seem impossible to think about building on this approach to > eventually handle that part of the problem better, too. I haven't > thought too much about what that would look like, but I think it could > be done. Perhaps run through pg_class after restart and flush anything marked relistemp? Although the ideal solution, probably, would be for temp tables to not have persistent catalog entries in the first place. regards, tom lane