Utilizing multiple cores for one query

Поиск
Список
Период
Сортировка
От henk de wit
Тема Utilizing multiple cores for one query
Дата
Msg-id BAY124-W312F15BBE3D85AE1D472F8F5720@phx.gbl
обсуждение исходный текст
Ответы Re: Utilizing multiple cores for one query
Список pgsql-performance
I wonder whether the current versions of postgres (i.e. either 8.2 or 8.3) are able to utilize multiple cores for the execution of a single query?

This is one thing that systems like SQL Server and Oracle have been able to do for quite some time. I haven't seen much in the documentation that hints that this may be possible in PG, nor did I find much in the mailinglists about this. The only thing I found was a topic that discussed some patches that may eventually lead to a sequence scan being handled by multiple cores.

Could someone shed some light on the current or future abilities of PG for making use of multiple cores to execute a single query?

Thanks in advance



Express yourself instantly with MSN Messenger! MSN Messenger

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

Предыдущее
От: cluster
Дата:
Сообщение: Re: Appending "LIMIT" to query drastically decreases performance
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Utilizing multiple cores for one query