Request a Demo
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 [email protected]
Whole thread Raw
In response to Re: Reducing memory usage of insert into select operations?  ("Douglas McNaught" <[email protected]>)
Responses Re: Reducing memory usage of insert into select operations?
List pgsql-general
Tree view 
On 9:53 am 07/18/08 "Douglas McNaught" <[email protected]> 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?