Re: postgres memory management
Alexander Jerusalem <ajeru@gmx.net>
From: Alexander Jerusalem <ajeru@gmx.net>
To: pgsql-general@postgresql.org
Date: 2001-01-21T16:01:34Z
Lists: pgsql-hackers, pgsql-general
Thank you for your answer Mark! Now I have updated glibc to the latest version (2.2) and it's still the same. I don't have the time to change to a different Linux version just to try if that solves the problem. What else could I do? thanks, Alexander Jerusalem ajeru@gmx.net At 15:49 21.01.01, you wrote: >First Things First. I would not use a .0 version of Redhat for anything. The >7.0 version is very buggy. Switch to Redhat 6.2 or another distribution like >Slackware 7.2. > > > 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 > > > >