Search Postgresql Archives

Re: Reducing memory usage of insert into select operations?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Francisco Reyes <lists@xxxxxxxxxxxxxxxx>
Subject: Re: Reducing memory usage of insert into select operations?
From: Richard Huxton <dev@xxxxxxxxxxxx>
Date: Fri, 18 Jul 2008 13:13:37 +0100
Cc: PostgreSQL general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <cone.1216344073.438238.29970.1000@xxxxxxxxxxxxxxxxxxx>
User-agent: Thunderbird 2.0.0.14 (X11/20080421)

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 breakingup a large table into smaller partitions.


Is the partition split done with triggers or rules?

--
  Richard Huxton
  Archonet Ltd

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Reducing memory usage of insert into select operations?
  - From: Francisco Reyes

References:
- Reducing memory usage of insert into select operations?
  - From: Francisco Reyes

Prev by Date: Re: Initdb problem on debian mips cobalt: Bus error
Next by Date: Re: Initdb problem on debian mips cobalt: Bus error
Previous by thread: Re: Reducing memory usage of insert into select operations?
Next by thread: Re: Reducing memory usage of insert into select operations?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux