Re: Reducing memory usage of insert into select operations?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reducing memory usage of insert into select operations?
Date: 2008-07-18 12:13:37
Message-ID: 488088F1.8090009@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-07-18 12:14:31 Re: Initdb problem on debian mips cobalt: Bus error
Previous Message Richard Huxton 2008-07-18 11:36:30 Re: Initdb problem on debian mips cobalt: Bus error