Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're running PostgreSQL on Windows Server 2008 (on Amazon EC2), with about 40 databases. When we first launch Postgres, it doesn't use much memory, but over time, the memory usage of ONE of the postgres.exe processes grows (all of the other remain at about 6 MB) until the system runs out of memory. This happens over the course of a few weeks. Right now, the postgres.exe process is using about 1.9 GB, but it will grow to about 2.3 GB eventually (which will max out the memory usage on the server), at which point we have to restart the Postgres service.

I realize this depends on a lot of factors that I'm not describing here, but what are some potential causes? Our postgresql.conf has not been changed from the default, which I understand has very conservative settings. Is this the expected memory usage? If our server had more memory, would it stabilize at some point?


share|improve this question
up vote 1 down vote accepted

Updated Postgres from 9.0.1 to 9.0.5 and this seems to have solved the problem.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.