Re: [HACKERS] Tuple count used while costing MergeAppend and that for an append rel

2016-11-20 Thread Ashutosh Bapat
> > AFAICS, what you propose to add in set_append_rel_size is pure overhead. > There's no conceivable use to computing sum-of-raw-tuple-counts for an > appendrel ... or at least, if there is, you didn't say what you expect > it would be good for. Normally the difference between rel->tuples and >

Re: [HACKERS] Tuple count used while costing MergeAppend and that for an append rel

2016-11-18 Thread Tom Lane
Ashutosh Bapat writes: > AFAIU, There's difference in the tuples and rows members of > RelOptInfo. While tuples gives the estimate of number of tuples per > pg_class, rows gives the number of rows output by that relation. From > that perspective rel->tuples should