Re: [PERFORM] Postgres on RAID5

2005-03-14 Thread Greg Stark
Alex Turner [EMAIL PROTECTED] writes: a 14 drive stripe will max out the PCI bus long before anything else, Hopefully anyone with a 14 drive stripe is using some combination of 64 bit PCI-X cards running at 66Mhz... the only reason for a stripe this size is to get a total accessible size

Re: [PERFORM] Postgres on RAID5

2005-03-14 Thread Michael Tokarev
Arshavir Grigorian wrote: Alex Turner wrote: [] Well, by putting the pg_xlog directory on a separate disk/partition, I was able to increase this rate to about 50 or so per second (still pretty far from your numbers). Next I am going to try putting the pg_xlog on a RAID1+0 array and see if that

RE: [PERFORM] Postgres on RAID5

2005-03-14 Thread Guy
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Tokarev Sent: Monday, March 14, 2005 5:47 PM To: Arshavir Grigorian Cc: linux-raid@vger.kernel.org; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Postgres on RAID5 Arshavir Grigorian wrote: Alex

Re: [PERFORM] Postgres on RAID5

2005-03-14 Thread Jim Buttafuoco
: Re: [PERFORM] Postgres on RAID5 Alex Turner [EMAIL PROTECTED] writes: a 14 drive stripe will max out the PCI bus long before anything else, Hopefully anyone with a 14 drive stripe is using some combination of 64 bit PCI-X cards running at 66Mhz... the only reason for a stripe this size

Re: [PERFORM] Postgres on RAID5

2005-03-13 Thread Greg Stark
Arshavir Grigorian [EMAIL PROTECTED] writes: Hi, I have a RAID5 array (mdadm) with 14 disks + 1 spare. This partition has an Ext3 filesystem which is used by Postgres. People are going to suggest moving to RAID1+0. I'm unconvinced that RAID5 across 14 drivers shouldn't be able to keep up