Re: postgres memory management
Alexander Jerusalem <ajeru@gmx.net>
From: Alexander Jerusalem <ajeru@gmx.net>
To: pgsql-general@postgresql.org
Date: 2001-01-21T21:27:45Z
Lists: pgsql-hackers, pgsql-general
Neil, thank you for your answer, I thought about that possibility and it is possible since that computer has 512 MB RAM. But when I start and stop other programs like emacs the memory is freed as soon as I stop them. As to KDE: I'm not concerned about a lack of memory in general but I'm about to deploy an application on a server that I hope will be running for a long time without me having to restart it every two days because of a memory leak in some software. Anyway, I hope you're right, I'll just try it :-) thanks, Alexander Jerusalem ajeru@gmx.net vknn At 18:49 21.01.01, Neil Conway wrote: >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@home.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