Re: Help with postgresql memory issue - Mailing list pgsql-general

From Thom Brown
Subject Re: Help with postgresql memory issue
Date
Msg-id bddc86150910281256w67700292tf45743061fb9cc90@mail.gmail.com
Whole thread Raw
In response to Help with postgresql memory issue  (Brooks Lyrette <brooks.lyrette@gmail.com>)
List pgsql-general
2009/10/28 Brooks Lyrette <brooks.lyrette@gmail.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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: PHP + PDO + PGPOOL = Segmentation fault
Next
From: Richard Huxton
Date:
Subject: Re: log slow queries and hints