Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 622F29FB79B for ; Tue, 12 Jun 2007 14:27:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91706-10 for ; Tue, 12 Jun 2007 14:26:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by postgresql.org (Postfix) with ESMTP id 84D829FB7A6 for ; Tue, 12 Jun 2007 14:26:57 -0300 (ADT) Received: by fafnir.androme.com (Postfix, from userid 1003) id A4CF2B94998; Tue, 12 Jun 2007 19:26:56 +0200 (CEST) Message-ID: <466ED760.6060202@andromeiberica.com> Date: Tue, 12 Jun 2007 19:26:56 +0200 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: A question about memory usage Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/104 X-Sequence-Number: 25772 Hi all, I have a server with 4GB of RAM and I wanted to know how much memory is being used by a PostgreSQL. To do so I have executed the following: ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 } END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }' And the result is: Real: 157.59MB Virtual: 6359.04MB So I understand that amount of virtual memory must be swapped to disk as it's bigger that my physical memory. To check this I have executed the free command and I get the following results: total used free shared buffers cached Mem: 4153180 3988536 164644 0 161400 3117900 -/+ buffers/cache: 709236 3443944 Swap: 6215672 64 6215608 So my question is, what I'm doing wrong? because the swap it's almost empty Thank you very much -- Arnau