Re: [PERFORM] linux distro for better pg performance

2004-05-04 Thread Aaron Werman
ogers" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, May 03, 2004 11:03 PM Subject: Re: [PERFORM] linux distro for better pg performance > Joseph Shraibman wrote: > > > J. Andrew Rogers wrote: > > > >> Do these features make a difference? Fa

Re: [PERFORM] linux distro for better pg performance

2004-05-03 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 >

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? On

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 Joseph Shraibman
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? On a 4 disk array with 3 da

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 bandwi

Re: [PERFORM] linux distro for better pg performance

2004-04-15 Thread Gavin M. Roy
I am searching for best pg distro to run pg (7.4.1). This is generally based upon opinion. Honestly though, your kernel version is more important for performance than the distro. Personally I use gentoo, love gentoo, and would recommend very few other distros (Slackware) for servers. RedH

[PERFORM] linux distro for better pg performance

2004-04-15 Thread pginfo
Hi, I am using pg from 3 y. and generaly I do not have big problems with it. I am searching for best pg distro to run pg (7.4.1). At the moment I am using RedHat AS 3.0, but I think it have some performance problems (I am not sure). My configuration: P4 2.8 GHz 1 GB RAM 120 GB IDE 7200 disk. Kern