Re: Reducing memory usage of insert into select operations?

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
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 03:10:18
Message-ID: 5ded07e00807172010y110df6d1xebf804cbf2e97686@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 17, 2008 at 7:21 PM, Francisco Reyes <lists(at)stringsutils(dot)com> wrote:
> Redhat 4
> postgresql 8.3.3
> Memory: 12GB
>
> While doing a couple of operations of the type
> insert into <table> select from <some other table>
>
> The OS triggered the out of memory killer (oom-killer).

Is this a 32-bit installation or 64-bit? 3GB of shared_buffers is way
too big for a 32-bit setup.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2008-07-18 03:27:06 Re: Reducing memory usage of insert into select operations?
Previous Message Bruce Momjian 2008-07-18 02:23:29 Re: TODO list and "hyphen"