Postgres Pro
Downloads
Home   >   mailing lists

Re: Reducing memory usage of insert into select operations? - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Reducing memory usage of insert into select operations?
Date
Msg-id ac44dd59c6c8b8eacfe38e074f11af87@stringsutils.com
Whole thread Raw
In response to Re: Reducing memory usage of insert into select operations?  ("Douglas McNaught" <doug@mcnaught.org>)
Responses Re: Reducing memory usage of insert into select operations?
List pgsql-general
Tree view 
On 9:53 am 07/18/08 "Douglas McNaught" <doug@mcnaught.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.

pgsql-general by date:

Previous
From: "Kevin Duffy"
Date:
Subject: Re: query optimization
Next
From: "Francisco Reyes"
Date:
Subject: Re: Reducing memory usage of insert into select operations?