From: | Rahila Syed <rahilasyed90(at)gmail(dot)com> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Parallel Index-only scan |
Date: | 2017-01-12 12:09:26 |
Message-ID: | CAH2L28vhK_2zC-eO4iKR_ow6=nz2K=4qa3wQjQLvifHXVs1ACQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
On applying the patch on latest master branch and running regression tests
following failure occurs.
I applied it on latest parallel index scan patches as given in the link
above.
***
/home/rahila/postgres/postgres/src/test/regress/expected/select_parallel.out
2017-01-03 14:06:29.122022780 +0530
---
/home/rahila/postgres/postgres/src/test/regress/results/select_parallel.out
2017-01-12 14:35:56.652712622 +0530
***************
*** 92,103 ****
explain (costs off)
select sum(parallel_restricted(unique1)) from tenk1
group by(parallel_restricted(unique1));
! QUERY PLAN
! ----------------------------------------------------
HashAggregate
Group Key: parallel_restricted(unique1)
! -> Index Only Scan using tenk1_unique1 on tenk1
! (3 rows)
set force_parallel_mode=1;
explain (costs off)
--- 92,105 ----
explain (costs off)
select sum(parallel_restricted(unique1)) from tenk1
group by(parallel_restricted(unique1));
! QUERY PLAN
! -------------------------------------------------------------------
HashAggregate
Group Key: parallel_restricted(unique1)
! -> Gather
! Workers Planned: 4
! -> Parallel Index Only Scan using tenk1_unique1 on tenk1
! (5 rows)
IIUC, parallel operation being performed here is fine as parallel
restricted function occurs above Gather node
and just the expected output needs to be changed.
Thank you,
Rahila Syed
Attachment | Content-Type | Size |
---|---|---|
regression.diffs | application/octet-stream | 1.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Gilles Darold | 2017-01-12 12:14:28 | Re: Patch to implement pg_current_logfile() function |
Previous Message | Rafia Sabih | 2017-01-12 11:52:19 | Re: Parallel bitmap heap scan |