Re: [ADMIN] Recommended RAID for Postgres

2008-07-08 Thread Montaseri
I'd also vote for RAID-5, best disk utilization, good on read, bad on writes, performance is good due to stripping If you can get some hardware raid to do the job (vs software raid) than performance gets better...an HBA board as low as $150 will (at least) double your speed Medi On Mon, Jul 7, 2

Re: [ADMIN] Recommended RAID for Postgres

2008-07-07 Thread Mikko Partio
On Mon, Jun 30, 2008 at 3:30 PM, Thomas Bräutigam < [EMAIL PROTECTED]> wrote: > Hello all, > > I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra. What do you guys > recommend on RAID Levels for this Database. Which does Postgres recommend, > and with which do Postgres run very good or in t

Re: [ADMIN] Recommended RAID for Postgres

2008-07-01 Thread Thomas Bräutigam
ADMIN] Recommended RAID for Postgres On Mon, Jun 30, 2008 at 03:15:34PM +0200, Thomas Bräutigam wrote: > Why avoid RAID5? I though that would be good? Can you explain this? RAID5 has a lot of disadvantages, especially in terms of performance. .oO(There was a link posted recently...) > Writing i

Re: [ADMIN] Recommended RAID for Postgres

2008-06-30 Thread Michael Monnerie
On Montag, 30. Juni 2008 Thomas Bräutigam wrote: > Why avoid RAID5? RAID5 has very poor WRITE performance compared to RAID10, while READ is nearly the same speed. If you do not have a "branded" server like HP or IBM, I can recommend the Areca RAID controllers http://www.areca.com.tw/ their driv

Re: [ADMIN] Recommended RAID for Postgres

2008-06-30 Thread Tino Schwarze
On Mon, Jun 30, 2008 at 03:15:34PM +0200, Thomas Bräutigam wrote: > Why avoid RAID5? I though that would be good? Can you explain this? RAID5 has a lot of disadvantages, especially in terms of performance. .oO(There was a link posted recently...) > Writing in the DB, I add about 5-10 GB of data

Re: [ADMIN] Recommended RAID for Postgres

2008-06-30 Thread Thomas Bräutigam
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tino Schwarze Sent: Montag, 30. Juni 2008 14:53 To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Recommended RAID for Postgres On Mon, Jun 30, 2008 at 02:30:23PM +0200, Thomas Bräutigam wrote: > I have a pre

Re: [ADMIN] Recommended RAID for Postgres

2008-06-30 Thread Tino Schwarze
On Mon, Jun 30, 2008 at 02:30:23PM +0200, Thomas Bräutigam wrote: > I have a pretty huge Postgres DB, about 1,3 to 1,5 Terra. Thats plenty of data. > What do you guys recommend on RAID Levels for this Database. Which > does Postgres recommend, and with which do Postgres run very good or > in th