Re: Reducing memory usage of insert into select operations?

From: "Francisco Reyes" <lists(at)stringsutils(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: <doug(at)mcnaught(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reducing memory usage of insert into select operations?
Date: 2008-07-18 16:43:57
Message-ID: 18a7f9af81dcb203e10639a5fe1fe73c@stringsutils.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12:03 pm 07/18/08 Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:

> Perhaps you can try reducing the shared_buffers, to see if that helps
> more?

Will try.

> 8MB is quite small for workmem. More shared_buffers is not
> necessarily better.

Ok, but from everything I had read shared_buffers of 1/4 seemed like a
starting point. Will try reducing it to 2GB.

> Also, how much swap are you running?

Started out with 12GB (same as memory) and last night I added 24GB more.
I had 2 instances of inserts going so each exausted about 18GB of ram!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2008-07-18 16:46:09 Re: Reducing memory usage of insert into select operations?
Previous Message Jerry McRae 2008-07-18 16:40:12 Calling Python functions with parameters