Thread: postgres getting bigger and bigger ...

postgres getting bigger and bigger ...

From
"Thomas Heller"
Date:
Hi there!

I just wondered if it is normal that a running postmaster is getting bigger
and bigger the more time it runs. I have configured by postmaster to accept
a maximum of 64 sessions. When I start it each session is about 1,5 - 3mb of
RAM. After 3-4 days each process is about 140mb of RAM and my machine starts
swapping a lot. (1gig RAM). When I shutdown the DB and restart it each
process is small again but they are growing ... through that the db gets
slower and slower and I wonder how i can get by this high mem usage?

Im running on Redhat 6.2 (p3-800 + 1gig ram).


thnx,
Thomas