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 92A193A5526 for ; Tue, 25 Jan 2005 13:01:55 +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 55414-10 for ; Tue, 25 Jan 2005 13:01:43 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196]) by svr1.postgresql.org (Postfix) with ESMTP id 6AF693A5508 for ; Tue, 25 Jan 2005 13:01:45 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 71so67873wri for ; Tue, 25 Jan 2005 05:01:46 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=NrGK8FaKXEBQ7em2urVp+Xn7G3V0wk/uYW1tJVU8SFPgs5diagJhp2yFtThC3y+yPs0zhUUqxN79eVMUgxWL0QjhHYzpyUcZSXxs7QZzawOywPkQSoJEZARImyg9WGu3wPNPz+r53WBPmsweUk5MWj8RafQivYN8la/cg1HnurY= Received: by 10.54.36.11 with SMTP id j11mr532597wrj; Tue, 25 Jan 2005 05:01:45 -0800 (PST) Received: by 10.54.31.32 with HTTP; Tue, 25 Jan 2005 05:01:45 -0800 (PST) Message-ID: <2989532e05012505011e5a0cfa@mail.gmail.com> Date: Tue, 25 Jan 2005 18:31:45 +0530 From: Antony Paul Reply-To: Antony Paul To: pgsql-performance@postgresql.org Subject: PostgreSQL not utilising available memory Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.54 tagged_above=0 required=5 tests=FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/457 X-Sequence-Number: 10147 Hi all, I am running PostgreSQL 7.3.3 on a RHL 7.0 box with PIII and 512 MB RAM. Recenlty I upgraded the kernel from 2.2.16 to 2.4.28. Now the problem is Postgres is using only half of the memory now while before upgrading the kernel it was using full memory plus swap. If Postgres use the full available memory will it run faster ?. I disabled Higmemory support while compiling kernel. From Top total used free shared buffers cached Mem: 501 209 292 0 2 173 -/+ buffers/cache: 34 467 Swap: 501 0 501 rgds Antony Paul