Skip site navigation (1) Skip section navigation (2)

Re: Time to commit a change

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>,PostgreSQL Mailing list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Time to commit a change
Date: 2002-12-12 17:49:08
Message-ID: web-2278813@davinci.ethosmedia.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-performance by date

Next:From: Ron JohnsonDate: 2002-12-12 17:57:57
Subject: Re: Capping CPU usage?
Previous:From: Josh BerkusDate: 2002-12-12 17:43:25
Subject: Re: Capping CPU usage?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group