Re: VACUUM hanging on idle system

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Clarence" <clarence1126(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM hanging on idle system
Date: 2006-06-24 03:27:38
Message-ID: 1302.1151119658@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Clarence" <clarence1126(at)gmail(dot)com> writes:
> Tom Lane wrote:
>> I seem to recall having fixed a bug like this in the past. What PG
>> version are you running?

> We're running 8.0.3

Um. Extract from the 8.0.5 CVS logs:

2005-12-08 14:19 tgl

* src/backend/: postmaster/bgwriter.c, utils/resowner/resowner.c
(REL8_0_STABLE): Fix bgwriter's failure to release buffer pins and
open files after an error. This probably explains bug #2099 and
could also account for mysterious VACUUM hangups.

8.0 branch is currently at 8.0.8 ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-06-24 17:08:43 Re: Form builder?
Previous Message John Tregea 2006-06-24 00:11:08 Re: Return the primary key of a newly inserted row?