Re: bgwriter holds onto file handles of deleted files - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: bgwriter holds onto file handles of deleted files
Date
Msg-id CAMkU=1xhs8cBhw0rB6HeF0spwYZ6BF5fo9-bkwkxhMKnEHkbCg@mail.gmail.com
Whole thread Raw
In response to bgwriter holds onto file handles of deleted files  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
On 1/8/12, Alex Shulgin <ash@commandprompt.com> wrote:
>
> Jeff Janes <jeff.janes@gmail.com> writes:
>
>> It looks like it hold the file handles until either is it is killed
>> and restarted, or until they get flushed out of vfd cache (which holds
>> ~1000 files on my machine, so that can be a long time and lot of disk
>> space).
>>
>> I don't know if this is a bug exactly, but it seems pretty unfortunate.
>
> I wonder if this is similar to what we've experienced here (follow the
> thread for the actual patches):
> http://archives.postgresql.org/pgsql-hackers/2011-06/msg00295.php
>
> Maybe you're running a version still affected by that bug?

Hi Alex,

I'm running git HEAD.  Sorry, I should have stated that.

Cheers,

Jeff


pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: [v9.2] Fix Leaky View Problem
Next
From: Kohei KaiGai
Date:
Subject: [v9.2] LEAKPROOF attribute of FUNCTION (Re: [v9.2] Fix Leaky View Problem)