Re: Negative cost is seen for plan node

2020-03-26 Thread Richard Guo
On Tue, Mar 24, 2020 at 12:01 PM Kyotaro Horiguchi wrote: > At Mon, 23 Mar 2020 21:13:48 +0800, Richard Guo > wrote in > > Hi all, > > > > With the following statements on latest master (c81bd3b9), I find > > negative cost for plan nodes. > > > > create table a (i int, j int); > > insert into a

Re: Negative cost is seen for plan node

2020-03-23 Thread Kyotaro Horiguchi
At Mon, 23 Mar 2020 21:13:48 +0800, Richard Guo wrote in > Hi all, > > With the following statements on latest master (c81bd3b9), I find > negative cost for plan nodes. > > create table a (i int, j int); > insert into a select i%10, i from generate_series(1,100)i; > analyze a; > > #

Negative cost is seen for plan node

2020-03-23 Thread Richard Guo
Hi all, With the following statements on latest master (c81bd3b9), I find negative cost for plan nodes. create table a (i int, j int); insert into a select i%10, i from generate_series(1,100)i; analyze a; # explain select i from a group by i; QUERY PLAN