Re: holdable cursors - Mailing list pgsql-patches

From Matthew T. O'Connor
Subject Re: holdable cursors
Date
Msg-id 030601c2f7a7$e32d4870$4a65a8c0@hplaptop
Whole thread Raw
In response to holdable cursors  (Neil Conway <neilc@samurai.com>)
Responses Re: holdable cursors
List pgsql-patches
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....


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: array support patch phase 1 patch
Next
From: Tom Lane
Date:
Subject: Re: holdable cursors