"Mike Mascari" <mascarm@mascari.com> writes > "Consider parallel processing a single query" should be moved out from > under Miscellaneous on the TODO list and re-categorized as the formerly > existent URGENT feature... >
Yes, inter/inner-operation of PQO could be an obvious winner in some situations. For example, in a rather idle multi-processor machine, run a complex query could get times of acceleration. However, in some other cases, like in a quite busy machine, inter-query parallel mechanism is already good enough, esp. for the system like PG using MVCC concurrency control. I remember there was someone working on the parallel scan idea of PG, I believe that's more realistic and benefitial than the implementation of the full set of PQO. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org