Slashdot Mirror

← Back to Stories (view on slashdot.org)

PostgreSQL Getting Parallel Query

Posted by samzenpus on from the new-and-improved dept.

New submitter iamvego writes: A major feature PostgreSQL users have requested for some time now is to have the query planner "parallelize" a query. Now, thanks to Robert Haas and Amit Kapila, this has now materialized in the 9.6 branch. Robert Haas writes in his blog entry that so far it only supports splitting up a sequential scan between multiple workers, but should hopefully be extended to work with multiple partitions before the final release, and much more beside in future releases.

2 of 83 comments (clear)

  1. Re:New features every few months by phantomfive · · Score: 4, Insightful

    PostgreSQL has one of the best-commented and cleanest code-base I've ever reviewed. FWIW

    --
    "First they came for the slanderers and i said nothing."
  2. Re:How does this compare with other databases? by Anonymous Coward · · Score: 2, Insightful

    Oracle has had this capability for at least a decade.

    On the other hand it is often worth it to rewrite your application entirely or ditch the customer that needs that particular function to not have to deal with Oracle.