Re: Multi CPU Queries - Feedback and/or suggestions wanted!

From: Julius Stroffek <Julius(dot)Stroffek(at)Sun(dot)COM>
To: Jeffrey Baker <jwbaker(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Dano Vojtek <danielkov(at)gmail(dot)com>
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!
Date: 2008-10-21 20:49:36
Message-ID: 48FE4060.8050702@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Jeffrey,

thank you for the suggestion. Yes, they potentially can, we'll consider
this.

Julo

Jeffrey Baker wrote:
> I don't see why multiple CPUs can't work on the same node of a plan.
> For instance, consider a node involving a scan with an expensive
> condition, like UTF-8 string length. If you have four CPUs you can
> bring to bear, each CPU could take every fourth page, computing the
> expensive condition for each tuple in that page. The results of the
> scan can be retired asynchronously to the next node above.

>
> -jwb

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2008-10-21 20:52:58 Re: So what's an "empty" array anyway?
Previous Message Tom Lane 2008-10-21 20:47:26 Re: Regression in IN( field, field, field ) performance