pgsql: Fix regression in parallel planning against inheritance tables.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix regression in parallel planning against inheritance tables.
Date: 2017-03-14 18:40:55
Message-ID: E1cnrNP-0001Kr-AI@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix regression in parallel planning against inheritance tables.

Commit 51ee6f3160d2e1515ed6197594bda67eb99dc2cc accidentally changed
the behavior around inheritance hierarchies; before, we always
considered parallel paths even for very small inheritance children,
because otherwise an inheritance hierarchy with even one small child
wouldn't be eligible for parallelism. That exception was inadverently
removed; put it back.

In passing, also adjust the degree-of-parallelism comptuation for
index-only scans not to consider the number of heap pages fetched.
Otherwise, we'll avoid parallel index-only scans on tables that are
mostly all-visible, which isn't especially logical.

Robert Haas and Amit Kapila, per a report from Ashutosh Sharma.

Discussion: http://postgr.es/m/CAE9k0PmgSoOHRd60SHu09aRVTHRSs8s6pmyhJKWHxWw9C_x+XA@mail.gmail.com

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/2609e91fcf9dcf36af40cd0c5b755dccf6057df6

Modified Files
--------------
src/backend/optimizer/path/allpaths.c | 46 +++++++++++++++++++----------------
src/backend/optimizer/path/costsize.c | 11 +++++++--
src/include/optimizer/paths.h | 4 +--
3 files changed, 36 insertions(+), 25 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2017-03-14 19:02:01 pgsql: hash: Support WAL consistency checking.
Previous Message Tom Lane 2017-03-14 18:39:07 Re: pgsql: hash: Add write-ahead logging support.