Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id A24F01337BFE
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 12 May 2011 01:26:11 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 01954-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 12 May 2011 04:26:04 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from skunk.mtbrook.bozemanpass.com (skunk.mtbrook.bozemanpass.com
	[69.145.82.195])
	by mail.postgresql.org (Postfix) with ESMTP id C4F0A1337BFB
	for <pgsql-performance@postgresql.org>;
	Thu, 12 May 2011 01:26:02 -0300 (ADT)
Received: from [69.145.82.226] (unknown [69.145.82.226])
	(using TLSv1 with cipher AES256-SHA (256/256 bits))
	(No client certificate requested)
	by skunk.mtbrook.bozemanpass.com (Postfix) with ESMTP id B9F04558039
	for <pgsql-performance@postgresql.org>;
	Wed, 11 May 2011 21:25:59 -0700 (PDT)
Message-ID: <4DCB6149.8070907@boreham.org>
Date: Wed, 11 May 2011 22:25:45 -0600
From: David Boreham <david_list@boreham.org>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US;
	rv:1.9.2.17) Gecko/20110414 Thunderbird/3.1.10
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Postgres refusing to use >1 core
References: <BANLkTimohiUa6rOYdxYTwqmvSUg2CRYMHg@mail.gmail.com>
	<4DC81A3F020000250003D433@gw.wicourts.gov>
	<BANLkTimNTLqQgQeyu=FPOn-5x6F4XnVBJA@mail.gmail.com>
	<4DC81D56020000250003D438@gw.wicourts.gov>
	<BANLkTi=FH4rX-7OtS9ozjuyXQTNTiRqCmg@mail.gmail.com>
	<BANLkTinwkj7syvKkYzU_O7DD14EMzk2Zmg@mail.gmail.com>
	<BANLkTi=BvGMvsBNq8DUt=_MPJXZjcC0TWg@mail.gmail.com>
	<4DC8B893.3060908@postnewspapers.com.au>
	<BANLkTimi+2nviLvWU4zKGtG688+Z84DF6w@mail.gmail.com>
	<4DC9E733.8040809@postnewspapers.com.au>
	<BANLkTim9Gg15bQsaNOpoUKZjmyH-+1vNYQ@mail.gmail.com>
In-Reply-To: <BANLkTim9Gg15bQsaNOpoUKZjmyH-+1vNYQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201105/171
X-Sequence-Number: 43680

On 5/11/2011 9:17 PM, Aren Cambre wrote:
>
> So here's what's going on.
>
<snip>

If I were doing this, considering the small size of the data set, I'd 
read all the data into memory.
Process it entirely in memory (with threads to saturate all the 
processors you have).
Then write the results to the DB.