> Anybody has a idea why it took that long to commit?
> My setup is a Pentium 4 with RAID 5. My version of
> postgresql is 7.2.2
Disk contention is also a very possible issue. I'd suggest trying the
same test when you are certain that no other disk activity is
happening. I've seen appalling wait times for random writes on some
Also, how about publishing the text of the function?
What controller are you using? How many dirves, of what type?
In response to
pgsql-performance by date
|Next:||From: Ron Johnson||Date: 2002-12-12 17:57:57|
|Subject: Re: Capping CPU usage?|
|Previous:||From: Josh Berkus||Date: 2002-12-12 17:43:25|
|Subject: Re: Capping CPU usage? |