Re: autovacuum with lots of open file references to deleted files

From: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To:
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: autovacuum with lots of open file references to deleted files
Date: 2012-11-05 01:40:22
Message-ID: 1352079622.31433.YahooMailNeo@web125901.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom --

<...>
>> A cron job dropdb one of the databases and createdb it and then pg_restore.
> Roughly 80GB dump.
>
> So far, my guess is that this is fixed by commits a1f064fc2 + d7598aeea.
>
>> Out production PostgreSQL running a 9.1 variant does not have this problem.
> It does not have the nightly dropdb/createdb/pg_restore, but otherwise similar
> usage patterins. It is also configured to use more memory.
>
> 9.1 has the same bug (and the same patches), but I think that the aspect
> you're running into is specific to DROP DATABASE scenarios.
>

Is there any idea of when this will be released ?

Thanks,

Greg W.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-11-05 02:21:55 Re: autovacuum with lots of open file references to deleted files
Previous Message Tom Lane 2012-11-05 00:47:35 Re: autovacuum with lots of open file references to deleted files