Re: [HACKERS] Parallel Index-only scan
| От | Rahila Syed |
|---|---|
| Тема | Re: [HACKERS] Parallel Index-only scan |
| Дата | |
| Msg-id | CAH2L28vhK_2zC-eO4iKR_ow6=nz2K=4qa3wQjQLvifHXVs1ACQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] Parallel Index-only scan (Amit Kapila <amit.kapila16@gmail.com>) |
| Ответы |
Re: [HACKERS] Parallel Index-only scan
|
| Список | pgsql-hackers |
Hello,
On applying the patch on latest master branch and running regression tests following failure occurs.--- /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.
and just the expected output needs to be changed.
Thank you,
Rahila Syed
Вложения
В списке pgsql-hackers по дате отправления: