"Clarence" <clarence1126@xxxxxxxxx> 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
