| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | "Hartman, Matthew" <Matthew(dot)Hartman(at)krcc(dot)on(dot)ca> |
| Cc: | Jean-David Beyer <jeandavid8(at)verizon(dot)net>, pgsql performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Utilizing multiple cores in a function call. |
| Date: | 2009-06-29 18:20:21 |
| Message-ID: | 4A4905E5.60009@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2009-06-29 18:42:18 | Re: Utilizing multiple cores in a function call. |
| Previous Message | Hartman, Matthew | 2009-06-29 15:01:57 | Re: Utilizing multiple cores in a function call. |