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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
