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 E6309D1BA35 for ; Sun, 22 Feb 2004 21:15:09 +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 63959-02 for ; Sun, 22 Feb 2004 17:15:07 -0400 (AST) Received: from localhost.localdomain (unknown [210.187.7.182]) by svr1.postgresql.org (Postfix) with ESMTP id 5A124D1B901 for ; Sun, 22 Feb 2004 17:15:04 -0400 (AST) Received: from i8600 (mail [127.0.0.1]) by localhost.localdomain (8.12.8/8.12.8) with SMTP id i1ML9iwb017232 for ; Mon, 23 Feb 2004 05:09:45 +0800 Message-ID: <007801c3f988$f1896e10$8f01a8c0@i8600> Reply-To: "Gyorgy Molnar" From: "Gyorgy Molnar" To: References: <296d84e62fc40fc6e1938b7086259dac@biglumber.com> <00f201c3f964$2d68baf0$0201a8c0@zwerg2000> <4038E2C6.6020108@potentialtech.com> Subject: System tuning Date: Mon, 23 Feb 2004 05:11:16 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/1010 X-Sequence-Number: 57721 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). I read the docuentation, and also the PostgreSQL Hardware Performance Tuning by Bruce Momjian. Both of them was very usefull, I could manage to come up with the configuration. Everything works fine, but I'm not sure I have chosen the best settings. Thank you in advance. Kind regards, Yuri ps. I almost forgot; I need 64 connections at the same times, and the max record length is aroung 1024 bytes.