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 E398FD1C9DA for ; Thu, 15 Apr 2004 04:17:53 -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 90604-05 for ; Thu, 15 Apr 2004 04:17:51 -0300 (ADT) Received: from mail.unisoftbg.com (unknown [194.12.229.207]) by svr1.postgresql.org (Postfix) with ESMTP id A4F44D1BB49 for ; Thu, 15 Apr 2004 04:17:44 -0300 (ADT) Received: (qmail 4808 invoked by uid 507); 15 Apr 2004 07:25:00 -0000 Received: from unknown (HELO t1.unisoftbg.com) (pginfo%t1.unisoftbg.com@194.12.229.193) by 0 with SMTP; 15 Apr 2004 07:25:00 -0000 Message-ID: <407E25A6.ADFE4815@t1.unisoftbg.com> Date: Thu, 15 Apr 2004 08:03:18 +0200 From: pginfo X-Mailer: Mozilla 4.03 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-performance@postgresql.org" Subject: linux distro for better pg performance Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=BAYES_40, RCVD_IN_DSBL, TO_ADDRESS_EQ_REAL X-Spam-Level: * X-Archive-Number: 200404/168 X-Sequence-Number: 6468 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. Kernel version 2.4.21-4.EL (it is the installation vesrion for rh 3.0) . 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). 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? Can I get better performance by using 15K SCSI disk ? Or it will be better to have more RAM (2 or 3 GB) ? regards, ivan.