Asking for assistance in determining storage requirements

From: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Asking for assistance in determining storage requirements
Date: 2009-07-09 15:15:24
Message-ID: BLU149-W280DAA87FCB62F151C8744D4260@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


You assistance is appreciated.

I have question regarding disk
storage for postgres servers

We are thinking long term about
scalable storage and performance and would like some advise
or feedback about
what other people are using.

We would like to get as much
performance from our file systems as possible.

We use ibm 3650 quad processor with
onboard SAS controller ( 3GB/Sec) with 15,000rpm drives.
We use raid 1 for the centos
operating system and the wal archive logs.
The postgres database is on 5 drives
configured as raid 5 with a global hot spare.

We are curious about using SAN with
fiber channel hba and if anyone else uses this technology.
We would also like to know if people
have preference to the level of raid with/out
striping.

Sincerely,

Chris Barnes
Recognia Inc.
Senior DBA

_________________________________________________________________
Attention all humans. We are your photos. Free us.
http://go.microsoft.com/?linkid=9666046

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2009-07-09 15:25:21 Re: SELECT DISTINCT very slow
Previous Message Ben Harper 2009-07-09 15:09:13 SELECT DISTINCT very slow