From: "Tom Lane" <tgl@sss.pgh.pa.us>
> Neil Conway <neilc@samurai.com> writes:
> > On Sun, 2003-03-30 at 15:14, Tom Lane wrote:
> >> What do you do to ensure the temp files *do* get cleaned up eventually?
>
> > It would probably be good to clean up any remaining temp files when the
> > backend shuts down. Would that be ok?
>
> 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....