Re: opinion on disk speed

From: "Jeremy Haile" <jhaile(at)fastmail(dot)fm>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: opinion on disk speed
Date: 2005-12-09 14:15:25
Message-ID: 1134137725.8767.249418727@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> one other note, you probably don't want to use all the disks in a raid10
> array, you probably want to split a pair of them off into a seperate
> raid1 array and put your WAL on it.

Is a RAID 1 array of two disks sufficient for WAL? What's a typical
setup for a high performance PostgreSQL installation? RAID 1 for WAL
and RAID 10 for data?

I've read that splitting the WAL and data offers huge performance
benefits. How much additional benefit is gained by moving indexes to
another RAID array? Would you typically set the indexes RAID array up
as RAID 1 or 10?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jaime Casanova 2005-12-09 15:06:07 Re: Query not using index
Previous Message Kaloyan Iliev 2005-12-09 09:36:10 Query not using index