From: | Robert Haas <rhaas(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Add optimizer and executor support for parallel index-only scans |
Date: | 2017-02-19 10:29:34 |
Message-ID: | E1cfOkI-0004vt-Jf@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Add optimizer and executor support for parallel index-only scans.
Commit 5262f7a4fc44f651241d2ff1fa688dd664a34874 added similar support
for parallel index scans; this extends that work to index-only scans.
As with parallel index scans, this requires support from the index AM,
so currently parallel index-only scans will only be possible for btree
indexes.
Rafia Sabih, reviewed and tested by Rahila Syed, Tushar Ahuja,
and Amit Kapila
Discussion: http://postgr.es/m/CAOGQiiPEAs4C=TBp0XShxBvnWXuzGL2u++Hm1=qnCpd6_Mf8Fw@mail.gmail.com
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/0414b26bac09379a4cbf1fbd847d1cee2293c5e4
Modified Files
--------------
src/backend/executor/execParallel.c | 12 ++
src/backend/executor/nodeIndexonlyscan.c | 154 ++++++++++++++++++++++----
src/backend/optimizer/path/indxpath.c | 6 +-
src/include/executor/nodeIndexonlyscan.h | 9 ++
src/include/nodes/execnodes.h | 2 +
src/test/regress/expected/select_parallel.out | 29 ++++-
src/test/regress/sql/select_parallel.sql | 5 +
7 files changed, 191 insertions(+), 26 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-02-19 16:01:48 | pgsql: Make partitions automatically inherit OIDs. |
Previous Message | Robert Haas | 2017-02-19 08:34:46 | Re: [COMMITTERS] pgsql: Add new function dsa_allocate0. |