> Well, inserts create some locks - perhaps that's the problem...
> Otherwise, check the pg_locks view to see if you can figure it out.
FWIW, I've had this happen a couple of times, too. Unfortunately, it's
happend in the middle of the day so that I had to cancel the processes and
get the system back to normal in too much of a hurry to consider documenting
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Ron St-Pierre||Date: 2004-04-23 18:57:23|
|Subject: Re: Help with performance problems|
|Previous:||From: Shea,Dan [CIS]||Date: 2004-04-23 18:19:04|
|Subject: Re: Why will vacuum not end?|