Re: [PERFORM] linux distro for better pg performance

2004-05-04 Thread Greg Stark
Joseph Shraibman [EMAIL PROTECTED] writes: J. Andrew Rogers wrote: Do these features make a difference? Far more than you would imagine. On one postgres server I just upgraded, we went from a 3Ware 8x7200-RPM RAID-10 configuration to an LSI 320-2 SCSI 3x10k RAID-5, with 256M Is raid

Re: [PERFORM] linux distro for better pg performance

2004-05-03 Thread James Thornton
Joseph Shraibman wrote: Is raid 5 much faster than raid 10? On a 4 disk array with 3 data disks and 1 parity disk, you have to write 4/3rds the original data, while on raid 10 you have to write 2 times the original data, so logically raid 5 should be faster. RAID 5 will give you more capacity,

Re: [PERFORM] linux distro for better pg performance

2004-05-03 Thread Alan Stange
Joseph Shraibman wrote: J. Andrew Rogers wrote: Do these features make a difference? Far more than you would imagine. On one postgres server I just upgraded, we went from a 3Ware 8x7200-RPM RAID-10 configuration to an LSI 320-2 SCSI 3x10k RAID-5, with 256M Is raid 5 much faster than raid 10?

Re: [PERFORM] linux distro for better pg performance

2004-04-15 Thread J. Andrew Rogers
On Thu, 2004-04-15 at 06:39, Gavin M. Roy wrote: Your IDE drive is the biggest hardward bottleneck here. RPM's and bus transfers are slower than SCSI or SATA. Individual disk throughput generally has very little bearing on database performance compared to other factors. In fact, IDE