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 0C062D1BAA2 for ; Wed, 21 Apr 2004 13:29:13 -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 28269-08 for ; Wed, 21 Apr 2004 13:29:10 -0300 (ADT) Received: from gin.mims.be (gin.mims.be [217.145.39.2]) by svr1.postgresql.org (Postfix) with SMTP id 659AFD1B4C3 for ; Wed, 21 Apr 2004 13:29:08 -0300 (ADT) Received: (qmail 50561 invoked from network); 21 Apr 2004 16:29:05 -0000 Received: from localhost by gin.mims.be (uid 82) with SMTP (mims-scanner-1.3, 0.378714 s); 21 Apr 2004 16:29:05 -0000 Received: from 213-193-172-189.adsl.easynet.be (HELO frmims) (213.193.172.189) by gin.mims.be with SMTP; 21 Apr 2004 16:29:05 -0000 Message-ID: <009901c427bd$c4752410$c601a8c0@MIMS> From: =?iso-8859-1?Q?Fr=E9d=E9ric_Robinet?= To: Subject: Shared buffers, Sort memory, Effective Cache Size Date: Wed, 21 Apr 2004 18:29:06 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Flag: NO X-Virus-Scanner: F-Prot v4.4.1 (engine v3.14.11) X-Virus-Definitions: SIGN.DEF (21 April 2004), SIGN2.DEF (21 April 2004), MACRO.DEF (21 April 2004) X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/352 X-Sequence-Number: 6652 Hello, I have a bi-PIII server with 2Gb of RAM with Debian and a PostgreSQL 7.4 running on. What are the bests settings for shared buffers, sort memory and effective cache size? My main database have a small/mid range size: some tables may have 1 or 2 millions of records. Thanks Frédéric Robinet Fr@Mims.be