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 1EC2BDA69D for ; Fri, 21 Oct 2005 00:36:44 -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 38033-09 for ; Fri, 21 Oct 2005 03:36:41 +0000 (GMT) Received: from mailer.eglobalreach.net (mail.padalacentral.com [202.124.128.22]) by svr1.postgresql.org (Postfix) with ESMTP id 9D607D9E93 for ; Fri, 21 Oct 2005 00:36:40 -0300 (ADT) Received: from ghwk02002147 (localhost [127.0.0.1] (may be forged)) by mailer.eglobalreach.net (8.11.6p2/) with ESMTP id j9L3acN29123 for ; Fri, 21 Oct 2005 11:36:38 +0800 From: "Christian Paul B. Cosinas" To: Subject: Used Memory Date: Fri, 21 Oct 2005 03:40:47 -0000 Message-ID: <00a401c5d5f1$39f661d0$1e21100a@ghwk02002147> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A5_01C5D5F1.39F7E870" X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <3cf983d0510181107sb060171je702da5fe0c29252@mail.gmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-Index: AcXUD9MHSbjkud3OSMqeu5cWHK1SMQB4GQiQ X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.679 required=5 tests=[AWL=-0.001, FORGED_RCVD_HELO=0.05, HTML_MESSAGE=0.001, URIBL_SBL=0.629] X-Spam-Level: X-Archive-Number: 200510/288 X-Sequence-Number: 15056 This is a multi-part message in MIME format. ------=_NextPart_000_00A5_01C5D5F1.39F7E870 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit HI! I am having a confusion to the memory handling of postgreSQL. Here is the Scenario. I rebooted my Server which is a PostgreSQL 8.0 Running on Redhat 9, which is a Dual Xeon Server and 6 gig of memory. Of course there is not much memory still used since it is just restarted. But after a number of access to the tables the memory is being used and it is not being free up. Actually after this access to the database and the server is just idle The memory is still used up. I am monitoring this using the "free" command which gives me about 5.5 gig of used memory and the rest free. Is there something that I should do to minimize and free up the used memory? Thanks You. I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html ------=_NextPart_000_00A5_01C5D5F1.39F7E870 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

HI!

I am having a confusion to the = memory handling of postgreSQL.

Here is the = Scenario.

I rebooted my Server which is a = PostgreSQL 8.0 Running on Redhat 9, which is a Dual Xeon Server and 6 gig of = memory.

Of course there is not much memory = still used since it is just restarted.

But after a number of access to the = tables the memory is being used and it is not being free up. Actually after = this access to the database and the server is just = idle

The memory is still used up. I am monitoring this using the “free” command which gives me = about 5.5 gig of used memory and the rest free.

Is there something that I should do = to minimize and free up the used memory?

Thanks = You.

I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html ------=_NextPart_000_00A5_01C5D5F1.39F7E870--