Thread

1. Postgresql and Software RAID/LVM

   Steve Poe <spoe@sfnet.cc> — 2005-06-03T18:45:29Z

   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?
   
   I don't forsee more 10-15 concurrent sessions running for an their OLTP
   application.
   
   Thanks.
   
   Steve Poe
   
   
   

2. Re: Postgresql and Software RAID/LVM

   Joshua D. Drake <jd@commandprompt.com> — 2005-06-03T22:03:17Z

   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?
   
   I would not run RAID + LVM in a software scenario. Software RAID is fine 
   however.
   
   Sincerely,
   
   Joshua D. Drake
   
   
   > 
   > I don't forsee more 10-15 concurrent sessions running for an their OLTP
   > application.
   > 
   > Thanks.
   > 
   > Steve Poe
   > 
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 6: Have you searched our list archives?
   > 
   >                http://archives.postgresql.org
   
   
   -- 
   Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
   PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
   Managed Services, Shared and Dedicated Hosting
   Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
   
   

3. Re: Postgresql and Software RAID/LVM

   Andrew McMillan <andrew@catalyst.net.nz> — 2005-06-06T06:48:45Z

   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
   -------------------------------------------------------------------------