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