> I take it then that the char time and the nurse time are not the same
> duration. Does the nurse time always have to be the same portion of
> the chair time (say, at the beginning?), or is their some more
> complicated definition of how the nurse time overlays on top the chair
> time during the
On Tue, Jun 30, 2009 at 8:30 AM, Hartman,
Matthew wrote:
> I have tried to wrap my brain around different approaches but I'm still
> stuck with this one so far. Your approach is interesting but the problem
> is more complicated than that. Let me break it down a bit more.
>
> The chemotherapy treatm
nformation Management, ICP
Kingston General Hospital
(613) 549- x4294
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Monday, June 29, 2009 5:22 PM
To: Hartman, Matthew
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Utilizing multiple cores in a fun
On Mon, 2009-06-29 at 14:42 -0400, Greg Smith wrote:
> -Write a "worker server" that you prompt to pick up work from a table and
> write its output to another that you can ask to handle part of the job.
> You might communicate with the worker using the LISTEN/NOTIFY mechanism in
> the database.
On Mon, Jun 29, 2009 at 10:26 AM, Hartman,
Matthew wrote:
> 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 s
On Mon, 29 Jun 2009, Hartman, Matthew wrote:
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?
Not easily. Potential techniques:
-Rewrite the function or its time critical portion in some
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
ilto:pgsql-performance-ow...@postgresql.org] On Behalf Of Jean-David
Beyer
Sent: Monday, June 29, 2009 10:53 AM
To: pgsql performance
Subject: Re: [PERFORM] Utilizing multiple cores in a function call.
Hartman, Matthew wrote:
> Good morning.
>
>
>
> I have developed a function call that schedu
Hartman, Matthew wrote:
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.
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
10 matches
Mail list logo
