Re: Postgres refusing to use >1 core

From: Aren Cambre <aren(at)arencambre(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres refusing to use >1 core
Date: 2011-05-12 03:18:12
Message-ID: BANLkTi=NC8UY4Se-Z_iJMVPWPMKyzc5fog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> > 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.
>

And the problem is my app already has between 20 and 30 threads. Something
about C#'s PLINQ may not be working as intended...

Aren

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Aren Cambre 2011-05-12 03:20:51 Re: Postgres refusing to use >1 core
Previous Message Aren Cambre 2011-05-12 03:17:00 Re: Postgres refusing to use >1 core