Re: parallelize queries containing initplans

tushar <tushar.ahuja@enterprisedb.com>

From: tushar <tushar.ahuja@enterprisedb.com>

To: Amit Kapila <amit.kapila16@gmail.com>, Robert Haas <robertmhaas@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, Haribabu Kommi <kommi.haribabu@gmail.com>, Kuntal Ghosh <kuntalghosh.2007@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2017-10-18T08:36:04Z

Lists: pgsql-hackers

Attachments

pip.sql (application/sql)
pip.out (text/plain)

On 10/11/2017 12:42 PM, tushar wrote:
> On 10/09/2017 03:26 PM, Amit Kapila wrote:
>> I have reverted the check
>> in the attached patch.
>
> I have applied this patch against PG HEAD and run sqlsmith and 
> analyzed results . didn't find any specific failures against this patch.
>
I did some testing of  this feature and written few testcases . PFA the 
sql  file(along with the expected .out file) .

-- 
regards,tushar
EnterpriseDB  https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

Commits

Pass InitPlan values to workers via Gather (Merge).
- e89a71fb449a 11.0 landed
Track in the plan the types associated with PARAM_EXEC parameters.
- e64861c79bda 11.0 landed
Force rescanning of parallel-aware scan nodes below a Gather[Merge].
- 7df2c1f8daeb 11.0 cited