pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
RAID 10 or RAID 10 + RAID 1 2+ messages / 2 participants [nested] [flat]
* RAID 10 or RAID 10 + RAID 1 @ 2007-08-14 10:14 Michael Ben-Nes <miki@epoch.co.il> 2007-08-14 21:31 ` Re: RAID 10 or RAID 10 + RAID 1 Decibel! <decibel@decibel.org> 0 siblings, 1 reply; 2+ messages in thread From: Michael Ben-Nes @ 2007-08-14 10:14 UTC (permalink / raw) To: pgsql-performance Hello, I need to setup a web server with PostgreSQL. The heaviest application will be product comparisons engine that will analyze 5-10 Million products. I have 6 SAS 15K disks, how should I set them up: RAID 10 on all 6 disks ( OS + Apache + PostgreSQL ) RAID 1 on 2 disks ( OS + Apache ) + RAID 10 on 4 disks ( PostgreSQL ) What is the recommended stripe size ( The computer is Dell PowerEdge 2950 ) Thanks, Miki -- -------------------------------------------------- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113 -------------------------------------------------- ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RAID 10 or RAID 10 + RAID 1 2007-08-14 10:14 RAID 10 or RAID 10 + RAID 1 Michael Ben-Nes <miki@epoch.co.il> @ 2007-08-14 21:31 ` Decibel! <decibel@decibel.org> 0 siblings, 0 replies; 2+ messages in thread From: Decibel! @ 2007-08-14 21:31 UTC (permalink / raw) To: Michael Ben-Nes <miki@epoch.co.il>; +Cc: pgsql-performance On Tue, Aug 14, 2007 at 01:14:39PM +0300, Michael Ben-Nes wrote: > Hello, > > I need to setup a web server with PostgreSQL. The heaviest application will > be product comparisons engine that will analyze 5-10 Million products. > > I have 6 SAS 15K disks, how should I set them up: > > RAID 10 on all 6 disks ( OS + Apache + PostgreSQL ) > RAID 1 on 2 disks ( OS + Apache ) + RAID 10 on 4 disks ( PostgreSQL ) If the controller is any good and has a battery-backed write cache, you'll probably do better with a 6 disk RAID10. If not, I'd put all the data on a 4 disk RAID10, and everything else (including pg_xlog!) on a mirror. > What is the recommended stripe size ( The computer is Dell PowerEdge 2950 ) If you search through the archives I think you'll find some stuff about stripe size and performance. As always, your best bet is to benchmark both approaches with your actual application. -- Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-08-14 21:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-08-14 10:14 RAID 10 or RAID 10 + RAID 1 Michael Ben-Nes <miki@epoch.co.il> 2007-08-14 21:31 ` Decibel! <decibel@decibel.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox