Re: Postgres refusing to use >1 core - Mailing list pgsql-performance

From Craig Ringer
Subject Re: Postgres refusing to use >1 core
Date
Msg-id 4DC9E7C5.9080309@postnewspapers.com.au
Whole thread Raw
In response to Postgres refusing to use >1 core  (Aren Cambre <aren@arencambre.com>)
Responses Re: Postgres refusing to use >1 core
Re: Postgres refusing to use >1 core
List pgsql-performance
On 11/05/11 05:34, Aren Cambre wrote:

> Using one thread, the app can do about 111 rows per second, and it's
> only exercising 1.5 of 8 CPU cores while doing this. 12,000,000 rows /
> 111 rows per second ~= 30 hours.

I don't know how I missed that. You ARE maxing out one cpu core, so
you're quite right that you need more threads unless you can make your
single worker more efficient.

Why not just spawn more copies of your program and have them work on
ranges of the data, though? Might that not be simpler than juggling
threading schemes?

--
Craig Ringer

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Postgres refusing to use >1 core
Next
From: Scott Marlowe
Date:
Subject: Re: Postgres NoSQL emulation