Re: Database Server Tuning - Mailing list pgsql-performance

From Vivek Khera
Subject Re: Database Server Tuning
Date
Msg-id 688B58EC-BAFE-11D8-AE8E-000A9578CFCC@kcilink.com
Whole thread Raw
In response to Re: Database Server Tuning  ("Anjan Dave" <adave@vantage.com>)
List pgsql-performance
On Jun 10, 2004, at 12:02 PM, Anjan Dave wrote:

> Vivek,
>
> Was there anything specific that helped you decide on a RAID-5 and not
> a RAID-10?

performance testing on restore times.  My DB is more than 50% write, so
I needed to optimize for writes.

> I have my DBs on RAID10, and would soon be moving them on FC drives,
> and i am considering RAID-10.

If I had to do it over again, I'd most likely go with RAID-50, and take
the hit on restore time for the advantage on reads.  I have to dig
through my records again to see the details... but then I have to do
all that for my OSCON presentation on this topic at the end of July in
Portland, OR. ;-)


Attachment

pgsql-performance by date:

Previous
From: "Anjan Dave"
Date:
Subject: Re: Database Server Tuning
Next
From: Jean-Luc Lachance
Date:
Subject: Re: *very* inefficient choice made by the planner (regarding