Re: holdable cursors

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: "Neil Conway" <neilc(at)samurai(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "PostgreSQL Patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: holdable cursors
Date: 2003-03-31 17:06:34
Message-ID: 030601c2f7a7$e32d4870$4a65a8c0@hplaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Neil Conway <neilc(at)samurai(dot)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....

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-03-31 17:09:40 Re: holdable cursors
Previous Message Neil Conway 2003-03-31 05:55:08 Re: Bug #928: server_min_messages (log_min_messages in CVS)