Re: Help with postgresql memory issue

From: Thom Brown <thombrown(at)gmail(dot)com>
To: Brooks Lyrette <brooks(dot)lyrette(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with postgresql memory issue
Date: 2009-10-28 19:56:04
Message-ID: bddc86150910281256w67700292tf45743061fb9cc90@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2009/10/28 Brooks Lyrette <brooks(dot)lyrette(at)gmail(dot)com>:
> There should be no other processes running, this system is dedicated to
> running postgresql.
>
> Max connections is configured to: max_connections = 400
>

Well it sounds like you've somehow run out of swap space. Are you
able to run top and sort by resident memory and also swap memory to
see where it's all going? Also use pg_top if you have it. That will
tell you how much memory each connection is using.

Thom

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-10-28 19:58:42 Re: log slow queries and hints
Previous Message Richard Huxton 2009-10-28 19:52:27 Re: PHP + PDO + PGPOOL = Segmentation fault