Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread justin
Scott Carey wrote: Sorry for the top post -- Assuming Linux -- 1: PERC 6 is still a bit inferior to other options, but not that bad. Its random IOPS is fine, sequential speeds are noticeably less than say the latest from Adaptec or Areca. In the archives there was big thread about this ve

Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread Scott Carey
Sorry for the top post -- Assuming Linux -- 1: PERC 6 is still a bit inferior to other options, but not that bad. Its random IOPS is fine, sequential speeds are noticeably less than say the latest from Adaptec or Areca. 2: Random iops will probably scale ok from 6 to 8 drives, but depending o

Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread Scott Carey
Sorry for the top posts, I don't have a client that is inline post friendly. Most PERCs are rebranded LSI's lately. The difference between the 5 and 6 is PCIX versus PCIe LSI series, relatively recent ones. Just look at the OpenSolaris drivers for the PERC cards for a clue to what is what.

Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread Scott Marlowe
On Wed, Feb 4, 2009 at 2:11 PM, Arjen van der Meijden wrote: > On 4-2-2009 21:09 Scott Marlowe wrote: >> >> I have little experience with the 6i. I do have experience with all >> the Percs from the 3i/3c series to the 5e series. My experience has >> taught me that a brand new, latest model $700

Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread Arjen van der Meijden
On 4-2-2009 21:09 Scott Marlowe wrote: I have little experience with the 6i. I do have experience with all the Percs from the 3i/3c series to the 5e series. My experience has taught me that a brand new, latest model $700 Dell RAID controller is about as good as a $150 LSI, Areca, or Escalade/3W

Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread Gary Doades
Rajesh Kumar Mallah wrote: Hi, I am going to get a Dell 2950 with PERC6i with 8 * 73 15K SAS drives + 300 GB EMC SATA SAN STORAGE, I seek suggestions from users sharing their experience with similar hardware if any. I have following specific concerns. 1. On list i read that RAID10 function in

Re: [PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread Scott Marlowe
On Wed, Feb 4, 2009 at 11:45 AM, Rajesh Kumar Mallah wrote: > Hi, > > I am going to get a Dell 2950 with PERC6i with > 8 * 73 15K SAS drives + > 300 GB EMC SATA SAN STORAGE, > > I seek suggestions from users sharing their experience with > similar hardware if any. I have following specific concern

[PERFORM] suggestions for postgresql setup on Dell 2950 , PERC6i controller

2009-02-04 Thread Rajesh Kumar Mallah
Hi, I am going to get a Dell 2950 with PERC6i with 8 * 73 15K SAS drives + 300 GB EMC SATA SAN STORAGE, I seek suggestions from users sharing their experience with similar hardware if any. I have following specific concerns. 1. On list i read that RAID10 function in PERC5 is not really strip

Re: [PERFORM] SSD performance

2009-02-04 Thread Jeff
On Feb 3, 2009, at 1:43 PM, Scott Carey wrote: I don’t think write caching on the disks is a risk to data integrity if you are configured correctly. Furthermore, these drives don’t use the RAM for write cache, they only use a bit of SRAM on the controller chip for that (and respect fsync),

Re: [PERFORM] Deleting millions of rows

2009-02-04 Thread Robert Haas
On Wed, Feb 4, 2009 at 7:35 AM, Gregory Stark wrote: > Robert Haas writes: > >> That's good if you're deleting most or all of the parent table, but >> what if you're deleting 100,000 values from a 10,000,000 row table? >> In that case maybe I'm better off inserting all of the deleted keys >> into

Re: [PERFORM] SSD performance

2009-02-04 Thread david
On Wed, 4 Feb 2009, Jeff wrote: On Feb 3, 2009, at 1:43 PM, Scott Carey wrote: I don?t think write caching on the disks is a risk to data integrity if you are configured correctly. Furthermore, these drives don?t use the RAM for write cache, they only use a bit of SRAM on the controller chip

Re: [PERFORM] Deleting millions of rows

2009-02-04 Thread Gregory Stark
Robert Haas writes: > That's good if you're deleting most or all of the parent table, but > what if you're deleting 100,000 values from a 10,000,000 row table? > In that case maybe I'm better off inserting all of the deleted keys > into a side table and doing a merge or hash join between the side

[PERFORM] Getting error while running DBT2 test for PostgreSQL

2009-02-04 Thread Rohan Pethkar
Hi All, I am trying to conduct DBT2 test for PostgreSQL. I am getting following errors when I run client and driver separately(Instead of running dbt2-run-workload script). I am also attaching exact error log file for the same. tid:1073875280 /home/rohan/NEW_DBT2/Installer/dbt2/src/driver.c:496 c