X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 33B2944F9F1 for ; Tue, 28 Dec 2004 05:47:59 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27934-06 for ; Tue, 28 Dec 2004 05:47:34 +0000 (GMT) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id 58E3244FFB3 for ; Tue, 28 Dec 2004 04:54:53 +0000 (GMT) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id iBS4skZ30827; Tue, 28 Dec 2004 13:54:46 +0900 Message-ID: <007e01c4ec99$a2a043a0$7201a8c0@mst1x5r347kymb> From: "Iain" To: , =?windows-874?B?UmFnbmFyIEhhZnN0YfA=?= Cc: References: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6> <00cb01c4ebb3$94aebf10$7201a8c0@mst1x5r347kymb> <45410.192.168.2.17.1104139293.squirrel@192.168.2.17> <003a01c4ebf7$503de6a0$7201a8c0@mst1x5r347kymb> <50978.192.168.2.17.1104161471.squirrel@192.168.2.17> <1104170919.23792.16.camel@localhost.localdomain> <58712.192.168.2.17.1104203972.squirrel@192.168.2.17> Subject: Re: Howto Increased performace ? Date: Tue, 28 Dec 2004 13:56:42 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="windows-874"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/304 X-Sequence-Number: 9679 Hi, These are the /etc/sysctl.conf settings that I am planning to use. Coincidentally, these are the settings recommended by Oracle. If anything they would be generous, I think. file-max 65536 (for 2.2 and 2.4 kernels) kernel.shmall 134217728 (=128MB) kernel.shmmax 268435456 fs.file-max 65536 By the way, when you tested your changes, was that with a busy system? I think that a configuration that gives the best performance (at the client end) on a machine with just a few connections might not be the configuration that will give you the best throughput when the system is stressed. I'm certainly no expert on tuning Linux systems, or even Postgres but I'd suggest that you become knowlegable in the use of the various system monitoring tools that Linux has and keep a record of their output so you can compare as you change your configuration. In the end though, I think your aim is to reduce swapping by tuning your memory usage for busy times. Also, I heard that (most?what versions?) 32 bit linux kernals are slow at handling more than 2GB memory so a kernal upgrade might be worth considering. regards Iain