X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 79BBC14B280B for ; Wed, 11 Aug 2004 18:46:29 -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 78801-06 for ; Wed, 11 Aug 2004 21:46:25 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 99BB414B2800 for ; Wed, 11 Aug 2004 18:46:23 -0300 (ADT) Received: from [134.22.70.202] (dyn-70-202.tor.dsl.tht.net [134.22.70.202]) by tht.net (Postfix) with ESMTP id 68C0076A09; Wed, 11 Aug 2004 17:46:30 -0400 (EDT) Subject: Re: Hardware upgrade for a high-traffic database From: Rod Taylor To: Jason Coene Cc: 'Merlin Moncure' , Postgresql Performance In-Reply-To: <200408112118.i7BLIR0E097522@mail.gotfrag.com> References: <200408112118.i7BLIR0E097522@mail.gotfrag.com> Content-Type: text/plain Message-Id: <1092260783.16087.96.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Wed, 11 Aug 2004 17:46:24 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/170 X-Sequence-Number: 7806 > I'm wondering why our PG server is using so little memory... The system has > 2GB of memory, though only around 200MB of it are used. Is there a PG This is the second time you've said this. Surely you're not implying there is 1.8GB Free Memory -- rather than 1.8GB in Buffers or Cache. Send output of the below: sysctl vm sysctl -a | grep buffers top | grep -E "(Mem|Swap):"