Обсуждение: using more then one CPU for queries

Поиск
Список
Период
Сортировка

using more then one CPU for queries

От
stig erikson
Дата:
from what i understand PostgreSQL only uses one CPU for any one query.

i do understand that on systems where there are many more connections
and simultaneous transactions (relatively small transactions) then the
number of processors, the queries would most likely run on a single
processor even if more processors were available.
on systems with many long running queries (possibly analytical) the same
would apply.

but on systems with relatively few queries compared to the number of
processors or on systems that have many small queries running and a few
large it could help run the large queries on more then one processor.

i would like to ask if there are some plans or if there has been any
discussions about allowing any one query to run on more then one processor?

tia.
stig

Re: using more then one CPU for queries

От
Peter Eisentraut
Дата:
stig erikson wrote:
> i would like to ask if there are some plans or if there has been any
> discussions about allowing any one query to run on more then one
> processor?

It is certainly on most people's wishlists but there is no concrete plan
for it yet.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/