Re: Postgresql and Software RAID/LVM - Mailing list pgsql-performance

From Andrew McMillan
Subject Re: Postgresql and Software RAID/LVM
Date
Msg-id 1118040525.10586.172.camel@lamb.mcmillan.net.nz
Whole thread Raw
In response to Postgresql and Software RAID/LVM  (Steve Poe <spoe@sfnet.cc>)
List pgsql-performance
On Fri, 2005-06-03 at 11:45 -0700, Steve Poe wrote:
> I have a small business client that cannot afford high-end/high quality
> RAID cards for their next server. That's a seperate argument/issue right
> there for me, but what the client wants is what the client wants.
>
> Has anyone ran Postgres with software RAID or LVM on a production box?
> What have been your experience?

Hi,

We regularly run LVM on top of software raid for our PostgreSQL servers
(and our other servers, for that matter).

As far as I can see these systems have not had issues related to either
software RAID or LVM - that's around 30 systems all up, maybe 8 running
PostgreSQL, in production.  The database servers are a variety of
dual-Xeon (older) and dual-Opteron (newer) systems.

The Xeons are all running Debian "Woody" with 2.4.xx kernels and the
Opterons are all running "Sarge" with 2.6.x kernels.

Regards,
                    Andrew.

-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/            PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201      MOB: +64(272)DEBIAN      OFFICE: +64(4)499-2267
       The secret of being a bore is to say everything -- Voltaire
-------------------------------------------------------------------------


Attachment

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: Most effective tuning choices for busy website?
Next
From: PFC
Date:
Subject: Re: SELECT DISTINCT Performance Issue