Re: bgwriter holds onto file handles of deleted files

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Alex Shulgin <ash(at)commandprompt(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: bgwriter holds onto file handles of deleted files
Date: 2012-01-08 15:42:13
Message-ID: CAMkU=1xhs8cBhw0rB6HeF0spwYZ6BF5fo9-bkwkxhMKnEHkbCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 1/8/12, Alex Shulgin <ash(at)commandprompt(dot)com> wrote:
>
> Jeff Janes <jeff(dot)janes(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kohei KaiGai 2012-01-08 15:52:04 [v9.2] LEAKPROOF attribute of FUNCTION (Re: [v9.2] Fix Leaky View Problem)
Previous Message Kohei KaiGai 2012-01-08 15:32:41 Re: [v9.2] Fix Leaky View Problem