Horton

Re: Parallel seq. plan is not coming against inheritance or partition table

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Ashutosh Sharma <ashu.coek88@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, tushar <tushar.ahuja@enterprisedb.com>
Date: 2017-03-14T18:41:41Z
Lists: pgsql-hackers 
On Mon, Mar 13, 2017 at 10:18 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> Agreed, so I have rebased your patch and passed heap_pages as -1 for
> index_only scans as discussed.   Also, Rafia has tested with attached
> patch that parallel index and parallel index only scans are picked for
> TPC-H queries.  I have also reviewed and tested your changes with
> respect to problem reported and found that it works as expected.  So,
> I think we can go ahead with attached patch unless you see some
> problem with the changes I have made.

OK, committed with a little more wordsmithing.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

  1. Fix regression in parallel planning against inheritance tables.

  2. Replace min_parallel_relation_size with two new GUCs.