> No, but data is constantly being inserted by userid scores. It is postgres
> runnimg the vacuum.
Well, inserts create some locks - perhaps that's the problem...
Otherwise, check the pg_locks view to see if you can figure it out.
Next:From: Aaron WermanDate: 2004-04-21 02:14:51
Subject: Re: Moving postgres to FC disks
Previous:From: Paul TuckfieldDate: 2004-04-21 00:34:13
Subject: Re: Wierd context-switching issue on Xeon