Re: postgres memory management

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres memory management
Date: 2001-01-21 17:49:49
Message-ID: 20010121124949.A12967@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc

On Sun, Jan 21, 2001 at 01:18:54PM +0100, Alexander Jerusalem wrote:
> When the database connection is closed, no memory is reclaimed, the overall
> memory usage stays the same. And when I close down all postgresql processes
> including postmaster, it's the same.
> I'm rather new to Linux and postgresql so I'm not sure if I should call
> this a memory leak :-)

How much memory is being used? Do you ever go into swap? If not,
what's probably happening is Linux is using free memory to cache data
like I/O. Linux should automatically release this memory if it's
needed by a process. So as long as you have some free memory, I'd
say don't worry about it -- but if you start going into swap and
this memory isn't released, then you might have a problem.

BTW, you're using 'ktop', the KDE front end to 'top'? If you're
concerned about memory usage, I'd definately recommend not running
KDE, X, or any other GUI stuff.

HTH,

Neil

--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Violence is to dictatorship as propaganda is to democracy.
-- Noam Chomsky

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-21 18:59:14 Re: ACS Web Server & PostgreSQL
Previous Message J.H.M. Dassen (Ray) 2001-01-21 17:46:38 Re: postgres memory management

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-01-21 18:34:50 Re: Re: [PATCHES] Patch to support transactions with BLOBs for current CVS
Previous Message Frank Joerdens 2001-01-21 17:46:50 Re: beta3 vacuum crash

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2001-01-21 18:39:22 Re: ODBC gives pq_recvbuf: unexpected EOF on client connection
Previous Message J.H.M. Dassen (Ray) 2001-01-21 17:46:38 Re: postgres memory management