Re: Reducing memory usage of insert into select operations?

From: "Francisco Reyes" <lists(at)stringsutils(dot)com>
To: " Douglas McNaught " <doug(at)mcnaught(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>, <lists(at)stringsutils(dot)com>
Subject: Re: Reducing memory usage of insert into select operations?
Date: 2008-07-18 14:40:02
Message-ID: ac44dd59c6c8b8eacfe38e074f11af87@stringsutils.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9:53 am 07/18/08 "Douglas McNaught" <doug(at)mcnaught(dot)org> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2008-07-18 14:41:23 Re: Reducing memory usage of insert into select operations?
Previous Message Kevin Duffy 2008-07-18 14:39:04 Re: query optimization