Re: [GENERAL] VACUUM hanging on idle system

2006-06-25 Thread Clarence
Tom Lane wrote: > 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 #20

Re: [GENERAL] VACUUM hanging on idle system

2006-06-23 Thread Tom Lane
"Clarence" <[EMAIL PROTECTED]> 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/reso

Re: [GENERAL] VACUUM hanging on idle system

2006-06-23 Thread Clarence
Tom Lane wrote: > "Clarence" <[EMAIL PROTECTED]> writes: > > I have a completely idle postgresql system (all backends "idle", none > > "in transaction"); every time I attempt to vacuum a particular table, > > it hangs after a while. > > ... > > In the system error log there is this line: > >cou

Re: [GENERAL] VACUUM hanging on idle system

2006-06-22 Thread Tom Lane
"Clarence" <[EMAIL PROTECTED]> writes: > I have a completely idle postgresql system (all backends "idle", none > "in transaction"); every time I attempt to vacuum a particular table, > it hangs after a while. > ... > In the system error log there is this line: >could not write block 32756 of re