X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 528ACD1D08B for ; Thu, 15 Apr 2004 10:40:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 34210-04 for ; Thu, 15 Apr 2004 10:40:10 -0300 (ADT) Received: from tetra.ehpg.net (tetra.ehpg.net [216.218.206.34]) by svr1.postgresql.org (Postfix) with ESMTP id 1AE91D1D085 for ; Thu, 15 Apr 2004 10:40:06 -0300 (ADT) Received: from adsl-68-120-225-71.dsl.irvnca.pacbell.net (ehpg.net) [68.120.225.71]by tetra.ehpg.netwith asmtp(Exim 4.21 #1 (Gentoo Linux 1.4))id 1BE76l-0007lt-96; Thu, 15 Apr 2004 06:40:47 -0700 Message-ID: <407E909F.9000101@ehpg.net> Date: Thu, 15 Apr 2004 06:39:43 -0700 From: "Gavin M. Roy" User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pginfo Cc: "pgsql-performance@postgresql.org" Subject: Re: linux distro for better pg performance References: <407E25A6.ADFE4815@t1.unisoftbg.com> In-Reply-To: <407E25A6.ADFE4815@t1.unisoftbg.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus-Scanned: Clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/176 X-Sequence-Number: 6476 >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. RedHat and others seem to include kitchensinkd, when it's not needed. >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. > > Your IDE drive is the biggest hardward bottleneck here. RPM's and bus transfers are slower than SCSI or SATA. >Kernel version 2.4.21-4.EL (it is the installation vesrion for rh 3.0) . > > Jump to 2.6, it's much better for performance related issues, in my experience. >My problems: > >If I run some query with many reads, I see a massive disk transfer : >procs memory swap io >system cpu > r b swpd free buff cache si so bi bo in cs us sy >id wa > 0 0 0 261724 3252 670748 0 0 0 4 105 19 0 0 >100 0 > 0 0 0 261724 3252 670748 0 0 0 0 101 11 0 0 >100 0 > 0 0 0 261724 3260 670748 0 0 0 4 104 19 0 0 >100 0 > 0 1 0 259684 3268 674112 0 0 964 7 131 57 0 0 >95 4 > 1 0 0 119408 3288 808540 0 0 27960 0 572 630 13 14 >24 49 > 1 1 0 15896 3292 914436 0 0 7984 44744 531 275 11 18 >24 47 > 0 2 0 16292 3296 924996 0 0 4145 6413 384 176 2 >5 0 92 > 0 1 0 19928 3316 928844 0 0 11805 13335 497 388 5 >9 5 81 > 0 3 0 19124 3296 924452 0 0 3153 19164 287 295 5 11 >16 68 > 0 1 0 15956 3304 932984 0 0 536 6812 366 123 4 >6 3 87 > 0 2 0 24956 3300 921416 0 0 1931 22936 > >And if I run top, I see a big iowait % (some times 70-80) and very low >user % (10-15). > > again, this is your harddrive, and the kernel can play into that. >I readet many docs about this problem, but do not find any solution. > >My question: > >If some one is using RH 3.0, pls post some result or suggestions for it >performance with pg . > >What is the best linux distro for pg? > > There's no best, just personal preference. >Can I get better performance by using 15K SCSI disk ? > > Absolutely >Or it will be better to have more RAM (2 or 3 GB) ? > > Better to have a fast drive, but more ram can be helpful. >regards, >ivan. > > > HTH, Gavin