Home > mailing lists

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

From	Douglas McNaught
Subject	Re: Reducing memory usage of insert into select operations?
Date	July 18, 2008 03:14:27
Msg-id	5ded07e00807172010y110df6d1xebf804cbf2e97686@mail.gmail.com Whole thread Raw
In response to	Reducing memory usage of insert into select operations? (Francisco Reyes <lists@stringsutils.com>)
List	pgsql-general

Tree view

On Thu, Jul 17, 2008 at 7:21 PM, Francisco Reyes <lists@stringsutils.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

pgsql-general by date:

From: Bruce Momjian
Date: 18 July 2008, 02:23:43
Subject: Re: TODO list and "hyphen"

From: "Douglas McNaught"
Date: 18 July 2008, 04:29:30
Subject: Re: Reducing memory usage of insert into select operations?

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

Previous

Next