Re: [PERFORM] Some Performance Advice Needed

2005-01-09 Thread Randolf Richardson
"[EMAIL PROTECTED] ("Joshua D. Drake")" wrote in pgsql.performance: > Jeff wrote: > >> >> On Dec 23, 2004, at 9:27 AM, Alex wrote: >> >> >>> Running hdparm reported >>> A) 920mb/s (SCSI 10k) >>> B) 270mb/s (SCSI 10k) >>> C) 1750mb/s (IDE 7.2k) >> >> >> >> IDE disks lie about write completio

Re: [PERFORM] Some Performance Advice Needed

2004-12-27 Thread Jeff
On Dec 23, 2004, at 4:27 PM, Joshua D. Drake wrote: IDE disks lie about write completion (This can be disabled on some drives) whereas SCSI drives wait for the data to actually be written before they report success. It is quite easy to corrupt a PG (Or most any db really) on an IDE drive. Check

Re: [PERFORM] Some Performance Advice Needed

2004-12-23 Thread William Yu
IDE disks lie about write completion (This can be disabled on some drives) whereas SCSI drives wait for the data to actually be written before they report success. It is quite easy to corrupt a PG (Or most any db really) on an IDE drive. Check the archives for more info. Do we have any real i

Re: [PERFORM] Some Performance Advice Needed

2004-12-23 Thread Joshua D. Drake
Jeff wrote: On Dec 23, 2004, at 9:27 AM, Alex wrote: Running hdparm reported A) 920mb/s (SCSI 10k) B) 270mb/s (SCSI 10k) C) 1750mb/s (IDE 7.2k) IDE disks lie about write completion (This can be disabled on some drives) whereas SCSI drives wait for the data to actually be written before th

Re: [PERFORM] Some Performance Advice Needed

2004-12-23 Thread William Yu
Alex wrote: Hi, i recently run pgbench against different servers and got some results I dont quite understand. A) EV1: Dual Xenon, 2GHz, 1GB Memory, SCSI 10Krpm, RHE3 B) Dual Pentium3 1.4ghz (Blade), SCSI Disk 10Krmp, 1GB Memory, Redhat 8 C) P4 3.2GHz, IDE 7.2Krpm, 1GBMem, Fedora Core2 > Runnig P

Re: [PERFORM] Some Performance Advice Needed

2004-12-23 Thread Jeff
On Dec 23, 2004, at 9:27 AM, Alex wrote: Running hdparm reported A) 920mb/s (SCSI 10k) B) 270mb/s (SCSI 10k) C) 1750mb/s (IDE 7.2k) IDE disks lie about write completion (This can be disabled on some drives) whereas SCSI drives wait for the data to actually be written before they report su

[PERFORM] Some Performance Advice Needed

2004-12-23 Thread Alex
Hi, i recently run pgbench against different servers and got some results I dont quite understand. A) EV1: Dual Xenon, 2GHz, 1GB Memory, SCSI 10Krpm, RHE3 B) Dual Pentium3 1.4ghz (Blade), SCSI Disk 10Krmp, 1GB Memory, Redhat 8 C) P4 3.2GHz, IDE 7.2Krpm, 1GBMem, Fedora Core2 All did run only postg