Utilizing multiple cores in a function call.

Поиск
Список
Период
Сортировка
От Hartman, Matthew
Тема Utilizing multiple cores in a function call.
Дата
Msg-id 366642367C5B354197A1E0D27BC175BD022597D6@KGHMAIL.KGH.ON.CA
обсуждение исходный текст
Ответы Re: Utilizing multiple cores in a function call.
Re: Utilizing multiple cores in a function call.
Re: Utilizing multiple cores in a function call.
Список 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

 

 

В списке pgsql-performance по дате отправления: