X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4D008DADA7 for ; Tue, 25 Oct 2005 04:24:41 -0300 (ADT) 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 27693-01 for ; Tue, 25 Oct 2005 07:24:38 +0000 (GMT) Received: from mailer.eglobalreach.net (cybees.com [202.124.128.22]) by svr1.postgresql.org (Postfix) with ESMTP id CD3C4DADC8 for ; Tue, 25 Oct 2005 04:24:38 -0300 (ADT) Received: from ghwk02002147 (localhost [127.0.0.1] (may be forged)) by mailer.eglobalreach.net (8.11.6p2/) with ESMTP id j9P7OdO25014 for ; Tue, 25 Oct 2005 15:24:39 +0800 From: "Christian Paul B. Cosinas" To: Subject: FW: Used Memory Date: Tue, 25 Oct 2005 07:28:51 -0000 Message-ID: <001701c5d935$bfc21970$1e21100a@ghwk02002147> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-Index: AcXYSRQEEzZVhwc+RZSn0P4xxglPcQAA3w8wADpH21A= X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.679 required=5 tests=[AWL=0.000, FORGED_RCVD_HELO=0.05, URIBL_SBL=0.629] X-Spam-Level: X-Archive-Number: 200510/351 X-Sequence-Number: 15119 Here are the configuration of our database server: port = 5432 max_connections = 300 superuser_reserved_connections = 10 authentication_timeout = 60 shared_buffers = 48000 sort_mem = 32168 sync = false Do you think this is enough? Or can you recommend a better configuration for my server? The server is also running PHP and Apache but wer'e not using it extensively. For development purpose only. The database slow down is occurring most of the time (when the memory free is low) I don't think it has something to do with vacuum. We only have a full server vacuum once a day. I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html