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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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