Re: Utilizing multiple cores in a function call. - Mailing list pgsql-performance

From Joe Conway
Subject Re: Utilizing multiple cores in a function call.
Date
Msg-id 4A4905E5.60009@joeconway.com
Whole thread Raw
In response to Re: Utilizing multiple cores in a function call.  ("Hartman, Matthew" <Matthew.Hartman@krcc.on.ca>)
List pgsql-performance
Hartman, Matthew wrote:
> I'm pretty much at that point where I've chewed the fat off of the
> algorithm, or at least at my personal limits. Occasionally a new idea
> pops into my head and yields an improvement but it's in the order of
> 100-250ms.
>
> Google came back with "no sir". It seems PostgreSQL is limited to one
> CPU per query unless I spawn a master/controller like you suggested.
> Shame..

Although I have never done it myself, you might try using PL/R to
perform the algo in R, and make use of snow package to run parallel
tasks -- see:
   http://cran.r-project.org/web/views/HighPerformanceComputing.html

Joe


pgsql-performance by date:

Previous
From: "Hartman, Matthew"
Date:
Subject: Re: Utilizing multiple cores in a function call.
Next
From: Greg Smith
Date:
Subject: Re: Utilizing multiple cores in a function call.