Re: postgres memory management

From: "J(dot)H(dot)M(dot) Dassen (Ray)" <jdassen(at)cistron-office(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres memory management
Date: 2001-01-21 17:46:38
Message-ID: 20010121184638.B8254@cistron-office.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc

On Sun, Jan 21, 2001 at 13:18:54 +0100, Alexander Jerusalem wrote:
> During that process postgresql continues to take up more and more memory
> and seemingly never returns it to the system. Oddly if I watch the
> postmaster and it's sub processes in ktop, I can't see which process takes
> up this memory. ktop shows that the postgresql related processes have a
> constant memory usage but the overall memory usage always increases as
> long as I continue to send insert statements.
>
> 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.

Linux uses memory that wouldn't otherwise be used as buffer/cache space
(watch the "cached" entry in "top"). This is nothing to worry about.

HTH,
Ray
--
USDoJ/Judge Jackson: "Microsoft has performed an illegal operation and will
be shut down."
James Turinsky in alt.sysadmin.recovery

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2001-01-21 17:49:49 Re: postgres memory management
Previous Message Alexander Jerusalem 2001-01-21 16:01:34 Re: postgres memory management

Browse pgsql-hackers by date

  From Date Subject
Next Message Frank Joerdens 2001-01-21 17:46:50 Re: beta3 vacuum crash
Previous Message Alexander Jerusalem 2001-01-21 16:01:34 Re: postgres memory management

Browse pgsql-jdbc by date

  From Date Subject
Next Message Neil Conway 2001-01-21 17:49:49 Re: postgres memory management
Previous Message Alexander Jerusalem 2001-01-21 16:01:34 Re: postgres memory management