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

Re: PostgreSQL strugling during high load

From: "Anjan Dave" <adave(at)vantage(dot)com>
To: <josh(at)agliodbs(dot)com>
Cc: "Donald Courtney" <Donald(dot)Courtney(at)sun(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL strugling during high load
Date: 2005-05-19 20:19:58
Message-ID: 4BAFBB6B9CC46F41B2AD7D9F4BBAF785026FF87E@vt-pe2550-001.vantage.vantage.com (view raw or flat)
Thread:
Lists: pgsql-performance
Yes, I am using it another DB/application. Few more days and I'll have a
free hand on this box as well.

Thanks,
Anjan

-----Original Message-----
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com] 
Sent: Thursday, May 19, 2005 3:58 PM
To: Anjan Dave
Cc: Donald Courtney; Tom Lane; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] PostgreSQL strugling during high load

Anjan,

> As far as disk I/O is concerned for flushing the buffers out, I am not
> ruling out the combination of Dell PERC4 RAID card, and the RH AS 3.0
> Update3 being a problem.

You know that Update4 is out, yes?  
Update3 is currenly throttling your I/O by about 50%.

-- 

--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-performance by date

Next:From: Jeffrey TennyDate: 2005-05-19 21:50:14
Subject: Which is better, correlated subqueries or joins?
Previous:From: Steve PoeDate: 2005-05-19 20:10:16
Subject: Re: PostgreSQL strugling during high load

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