X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5480355DBA for ; Thu, 24 Feb 2005 13:58:03 +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 35343-01 for ; Thu, 24 Feb 2005 13:58:02 +0000 (GMT) Received: from mail.eulerhermes.pl (mail.hermes-kredit.pl [217.153.119.83]) by svr1.postgresql.org (Postfix) with ESMTP id 1F2B455DB1 for ; Thu, 24 Feb 2005 13:58:01 +0000 (GMT) Received: from [192.168.49.9] (helo=xterm.podsiec) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1D4JMi-0007QA-JE for pgsql-admin@postgresql.org; Thu, 24 Feb 2005 14:49:16 +0100 From: Marcin Giedz Organization: Euler Hermes To: pgsql-admin@postgresql.org Subject: Configuration for my server Date: Thu, 24 Feb 2005 14:54:46 +0100 User-Agent: KMail/1.7.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200502241454.46733.marcin.giedz@eulerhermes.pl> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.868 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/279 X-Sequence-Number: 16447 Hello... Here is my server hardware configuration: 2x Xeon 1MB Cache 3GHZ + 4GB RAM basicly it one of Intel Server SR2400 configuration ;) with two Seagate discs 146GB 15k connected with RAID1. I have installed PSQL ver. 8.0 and try to find best configuration. Nowadys we have about 300 clients connected to mysql server (we plan to switch to postgresql) but in the future there will be even 1 thousand clients. Can anyone please help me what should I change in postgresql.conf to achieve very good performance ;) Thx Marcin