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.  (Jean-David Beyer <jeandavid8@verizon.net>)
Re: Utilizing multiple cores in a function call.  (Greg Smith <gsmith@gregsmith.com>)
Re: Utilizing multiple cores in a function call.  (Merlin Moncure <mmoncure@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: random slow query
Следующее
От: Jean-David Beyer
Дата:
Сообщение: Re: Utilizing multiple cores in a function call.