Re: holdable cursors

"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>> Yes, you need to do that. Leaving it for the next postmaster restart
>> isn't acceptable (production sites don't restart the postmaster often).

> Would it make any sense for vacuum to look around for (and clean up) unused
> temp files left either from this or sorts etc....

I see no need for that. If a backend leaves temp files on normal exit,
the backend is broken and must be fixed. If it leaves temp files upon
crashing, well we can't expect anything from it; but that scenario will
cause a postmaster restart, which will clean out the temp files.

regards, tom lane