Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-14 Thread Greg Smith
On 09/11/2011 06:44 PM, Anthony Presley wrote: We've currently got PG 8.4.4 running on a whitebox hardware set up, with (2) 5410 Xeon's, and 16GB of RAM. It's also got (4) 7200RPM SATA drives, using the onboard IDE controller and ext3. A few weeks back, we purchased two refurb'd HP DL360's

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-13 Thread Arjen van der Meijden
On 12-9-2011 0:44 Anthony Presley wrote: A few weeks back, we purchased two refurb'd HP DL360's G5's, and were hoping to set them up with PG 9.0.2, running replicated. These machines have (2) 5410 Xeon's, 36GB of RAM, (6) 10k SAS drives, and are using the HP SA P400i with 512MB of BBWC. PG is

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-13 Thread Anthony Presley
On Tue, Sep 13, 2011 at 1:22 AM, Arjen van der Meijden acmmail...@tweakers.net wrote: On 12-9-2011 0:44 Anthony Presley wrote: A few weeks back, we purchased two refurb'd HP DL360's G5's, and were hoping to set them up with PG 9.0.2, running replicated. These machines have (2) 5410

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-12 Thread Anthony Presley
On Sun, Sep 11, 2011 at 6:17 PM, Tomas Vondra t...@fuzzy.cz wrote: Dne 12.9.2011 00:44, Anthony Presley napsal(a): We've currently got PG 8.4.4 running on a whitebox hardware set up, with (2) 5410 Xeon's, and 16GB of RAM. It's also got (4) 7200RPM SATA drives, using the onboard IDE

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-12 Thread Anthony Presley
So, today, I did the following: - Swapped out the 5410's (2.3Ghz) for 5470's (3.33Ghz) - Set the ext4 mount options to be noatime,barrier=0,data=writeback - Installed PG 9.1 from the yum repo Item one: With the accelerator cache set to 0/100 (all 512MB for writing), loading the db /

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-12 Thread Gavin Flower
On 12/09/11 15:10, mark wrote: From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Anthony Presley Sent: Sunday, September 11, 2011 4:45 PM To: pgsql-performance@postgresql.org Subject: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-11 Thread Stephen Frost
* Anthony Presley (anth...@resolution.com) wrote: I was really hoping that with hardware RAID that something would be faster (loading times, queries, etc...). What am I doing wrong? ext3 and ext4 do NOT perform identically out of the box.. You might be running into the write barriers problem

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-11 Thread Tomas Vondra
Dne 12.9.2011 00:44, Anthony Presley napsal(a): We've currently got PG 8.4.4 running on a whitebox hardware set up, with (2) 5410 Xeon's, and 16GB of RAM. It's also got (4) 7200RPM SATA drives, using the onboard IDE controller and ext3. A few weeks back, we purchased two refurb'd HP DL360's

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-11 Thread Alan Hodgson
On September 11, 2011 03:44:34 PM Anthony Presley wrote: First thing I noticed is that it takes the same amount of time to load the db (about 40 minutes) on the new hardware as the old hardware. I was really hoping with the faster, additional drives and a hardware RAID controller, that this

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-11 Thread Scott Marlowe
On Sun, Sep 11, 2011 at 4:44 PM, Anthony Presley anth...@resolution.com wrote: We've currently got PG 8.4.4 running on a whitebox hardware set up, with (2) 5410 Xeon's, and 16GB of RAM.  It's also got (4) 7200RPM SATA drives, using the onboard IDE controller and ext3. A few weeks back, we

Re: [PERFORM] RAID Controller (HP P400) beat by SW-RAID?

2011-09-11 Thread mark
From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Anthony Presley Sent: Sunday, September 11, 2011 4:45 PM To: pgsql-performance@postgresql.org Subject: [PERFORM] RAID Controller (HP P400) beat by SW-RAID? We've currently got PG 8.4.4