Search Postgresql Archives

Re: out of memory woes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Just wanted to post an update. Not going too well. Each time the
scripts were run over this holiday weekend, more statements failed with
out of memory errors, including more and more create index statements
(it had only been clusters previously). Eventually, psql could not even
be called with a very simple one-row update:

psql: could not fork new process for connection: Cannot allocate memory

The logs are nothing but this message repeated at this point:

<2006-12-26 00:00:01 EST>LOG:  could not fork new process for
connection: Cannot allocate memory
<2006-12-26 00:00:01 EST>LOG:  could not fork new process for
connection: Cannot allocate memory
<2006-12-26 00:00:01 EST>LOG:  could not fork new process for
connection: Cannot allocate memory
<2006-12-26 00:00:01 EST>LOG:  could not fork new process for
connection: Cannot allocate memory
<2006-12-26 02:00:01 EST>LOG:  could not fork new process for
connection: Cannot allocate memory
<2006-12-26 02:00:01 EST>LOG:  could not fork new process for
connection: Cannot allocate memory
<2006-12-26 02:00:01 EST>LOG:  could not fork new process for
connection: Cannot allocate memory

I think I'm about ready to bounce the server every night unfortunately.

Thanks for listening,
Mark



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux