Utilizing multiple cores in a function call.

From: "Hartman, Matthew" <Matthew(dot)Hartman(at)krcc(dot)on(dot)ca>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Utilizing multiple cores in a function call.
Date: 2009-06-29 14:26:40
Message-ID: 366642367C5B354197A1E0D27BC175BD022597D6@KGHMAIL.KGH.ON.CA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Good morning.

I have developed a function call that schedules patient appointments
within a day based on several resource constraints. The algorithm has
been mentioned on here before and I have managed to tweak it down to 6-9
seconds from the original 27 seconds.

Of course, I want it to be faster still. The function throttles one of
my CPUs to 100% (shown as 50% in Task Manager) and leaves the other one
sitting pretty. Is there any way to use both CPUs?

Thanks,

Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549-6666 x4294

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-David Beyer 2009-06-29 14:52:58 Re: Utilizing multiple cores in a function call.
Previous Message Andres Freund 2009-06-29 13:36:05 Re: random slow query