Re: [HACKERS] Avoid parallel full and right join paths.

2016-04-20 Thread Peter Geoghegan
On Wed, Apr 20, 2016 at 6:43 PM, Alvaro Herrera wrote: > The brin.sql test does that ... I actually copied brin.sql when creating regression tests for external sorting, primarily because I wanted to test a variety of collations, without having any control of what they happen to be on the target.

Re: [HACKERS] Avoid parallel full and right join paths.

2016-04-20 Thread Alvaro Herrera
Michael Paquier wrote: > On Thu, Apr 21, 2016 at 7:13 AM, Peter Geoghegan wrote: > > On Wed, Apr 20, 2016 at 2:49 PM, Robert Haas wrote: > >> Committed. But I think the regression test needs more thought, so I > >> left that out. > > > > It would be nice if there was a fuzz testing infrastructur

Re: [HACKERS] Avoid parallel full and right join paths.

2016-04-20 Thread Michael Paquier
On Thu, Apr 21, 2016 at 7:13 AM, Peter Geoghegan wrote: > On Wed, Apr 20, 2016 at 2:49 PM, Robert Haas wrote: >> Committed. But I think the regression test needs more thought, so I >> left that out. > > It would be nice if there was a fuzz testing infrastructure that > verified that parallel pla

Re: [HACKERS] Avoid parallel full and right join paths.

2016-04-20 Thread Peter Geoghegan
On Wed, Apr 20, 2016 at 2:49 PM, Robert Haas wrote: > Committed. But I think the regression test needs more thought, so I > left that out. It would be nice if there was a fuzz testing infrastructure that verified that parallel plans produce the same answer as serial plans. -- Peter Geoghegan

Re: [HACKERS] Avoid parallel full and right join paths.

2016-04-20 Thread Robert Haas
On Tue, Apr 19, 2016 at 10:21 AM, Mithun Cy wrote: > Tests: > create table mytab(x int,x1 char(9),x2 varchar(9)); > create table mytab1(y int,y1 char(9),y2 varchar(9)); > insert into mytab values (generate_series(1,5),'aa','aaa'); > insert into mytab1 values (generate_series(1,1),'aa','aaa

[HACKERS] Avoid parallel full and right join paths.

2016-04-19 Thread Mithun Cy
Tests: create table mytab(x int,x1 char(9),x2 varchar(9)); create table mytab1(y int,y1 char(9),y2 varchar(9)); insert into mytab values (generate_series(1,5),'aa','aaa'); insert into mytab1 values (generate_series(1,1),'aa','aaa'); insert into mytab values (generate_series(1,50),'aa','