postgres memory management

From: Alexander Jerusalem <ajeru(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres memory management
Date: 2001-01-21 12:18:54
Message-ID: 4.3.2.7.0.20010121131817.00b0fe60@pop.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-jdbc

Hi all,

I'm experiencing some strange behaviour with postgresql 7.0.3 on Red Hat
Linux 7. I'm sending lots of insert statements to the postgresql server
from another machine via JDBC. 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.
I'm rather new to Linux and postgresql so I'm not sure if I should call
this a memory leak :-)
Has anybody experienced a similar thing?

thanks,
Alexander Jerusalemvknn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florent Guillaume 2001-01-21 14:39:49 Re: curval was Re: is PG able to handle a >500 GB Database?
Previous Message Lincoln Yeoh 2001-01-21 11:20:55 Re: why am i able to access my db with username and ANY password?

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-01-21 13:57:51 Re: BIT/BIT VARYING status
Previous Message Patrick Welche 2001-01-21 12:11:47 Re: C++ interface build on FreeBSD 4.2 broken?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Alexander Jerusalem 2001-01-21 16:01:34 Re: postgres memory management
Previous Message Cedar Cox 2001-01-21 10:47:09 ODBC gives pq_recvbuf: unexpected EOF on client connection