Re: best use of an EMC SAN - Mailing list pgsql-performance

From Gregory Stark
Subject Re: best use of an EMC SAN
Date
Msg-id 877ip7avda.fsf@oxford.xeocode.com
Whole thread Raw
In response to best use of an EMC SAN  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: best use of an EMC SAN
List pgsql-performance
"Dave Cramer" <pg@fastcrypt.com> writes:

> Assuming we have 24 73G drives is it better to make one big metalun and carve
> it up and let the SAN manage the where everything is, or is  it better to
> specify which spindles are where.

This is quite a controversial question with proponents of both strategies.

I would suggest having one RAID-1 array for the WAL and throw the rest of the
drives at a single big array for the data files. That wastes space since the
WAL isn't big but the benefit is big.

If you have a battery backed cache you might not need even that. Just throwing
them all into a big raid might work just as well.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-performance by date:

Previous
From: Dan Gorman
Date:
Subject: Re: best use of an EMC SAN
Next
From: Michael Fuhr
Date:
Subject: Re: Query Analyser