Re: Time to commit a change - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Time to commit a change
Date
Msg-id web-2278813@davinci.ethosmedia.com
Whole thread Raw
In response to Time to commit a change  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
List pgsql-performance
Ludwig,

>    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
RAID5 controllers.

Also, how about publishing the text of the function?

What controller are you using?   How many dirves, of what type?

-Josh Berkus

pgsql-performance by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Capping CPU usage?
Next
From: Ron Johnson
Date:
Subject: Re: Capping CPU usage?