On 9:53 am 07/18/08 "Douglas McNaught" <doug@xxxxxxxxxxxx> wrote: > dedicated database server you really don't ever want to have the OOM > killer triggered. Found that yesterday (vm.overcommit_memory=2). Agree that this is better than OOM. I still ran out of memory last night and postgres just failed on the malloc(), which as you mentioned is better. Reduced work_mem to 8MB and trying again.
