X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2FF30D1BA9F for ; Mon, 23 Feb 2004 07:58:44 +0000 (GMT) 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 79073-10 for ; Mon, 23 Feb 2004 03:58:37 -0400 (AST) Received: from anchor-post-37.mail.demon.net (anchor-post-36.mail.demon.net [194.217.242.86]) by svr1.postgresql.org (Postfix) with ESMTP id 6CEA6D1BA21 for ; Mon, 23 Feb 2004 03:58:35 -0400 (AST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-37.mail.demon.net with esmtp (Exim 3.35 #1) id 1AvAz5-0001Qr-0b; Mon, 23 Feb 2004 07:58:35 +0000 Received: by mainbox.archonet.com (Postfix, from userid 529) id 2E1B2163F1; Mon, 23 Feb 2004 07:58:34 +0000 (GMT) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id BC084163DE; Mon, 23 Feb 2004 07:58:31 +0000 (GMT) From: Richard Huxton To: "Gyorgy Molnar" , Subject: Re: System tuning Date: Mon, 23 Feb 2004 07:58:30 +0000 User-Agent: KMail/1.5 References: <296d84e62fc40fc6e1938b7086259dac@biglumber.com> <4038E2C6.6020108@potentialtech.com> <007801c3f988$f1896e10$8f01a8c0@i8600> In-Reply-To: <007801c3f988$f1896e10$8f01a8c0@i8600> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402230758.31141.dev@archonet.com> X-Bogosity: No, tests=bogofilter, spamicity=0.000000, version=0.15.3 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/1013 X-Sequence-Number: 57724 On Sunday 22 February 2004 21:11, Gyorgy Molnar wrote: > Greetings, > > I have a Linux RedHat 9.0 computer. It has 1G memory. Is there anybody who > could help me to fine tune the Kernel for PgSql, and also the with the > proper settings for the PgSql server. I have two additional java program > running on that computer, otherwise I used a custom installation with the > minimal neccessary packages (No X-Server is initalled). Well, you should probably read the tuning and configuration docs at: http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php Then, post your main config settings to the -performance list along with details of any problems you are seeing. Bear in mind that "best" performance depends on what queries you are executing, so optimising for one group of queries may involve trade-offs with others. -- Richard Huxton Archonet Ltd