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.

1 of 83 comments (clear)

  1. Re:I miss pgsql by mysidia · · Score: 1, Interesting

    That and the master-master replication suite from Percona.

    I think that is a good reason to pick MySQL.

    As much as I like Postgres..... it seems to be a heck of a lot easier to do replication with MySQL and put together a highly-survivable system.

    I'm not even sure how to even start to go about doing it with Postgres.... although in the past; I have had a Cold/Warm standby Postgres with Slony-L based replication; It was quite frankly, a PITA.