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