Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: Reducing memory usage of insert into select operations?
Date
Msg-id 488088F1.8090009@archonet.com
Whole thread Raw
In response to Reducing memory usage of insert into select operations?  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: Reducing memory usage of insert into select operations?
List pgsql-general
Tree view 
Francisco Reyes wrote:
> The OS triggered the out of memory killer (oom-killer).

> The table I am selecting from has a few hundred million rows.
> The table I am inserting into has partitions. I am benchmarking breaking
> up a large table into smaller partitions.

Is the partition split done with triggers or rules?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Initdb problem on debian mips cobalt: Bus error
Next
From: Glyn Astill
Date:
Subject: Re: Initdb problem on debian mips cobalt: Bus error