Re: Adjust ndistinct for eqjoinsel

2022-07-15 Thread Tom Lane
Zhenghua Lyu writes: > I run TPC-DS benchmark for Postgres and find the join size estimation has > several problems. > For example, Ndistinct is key to join selectivity's estimation, this > value does not take restrictions > of the rel, I hit some cases in the function eqjoinsel, nd

Adjust ndistinct for eqjoinsel

2022-07-15 Thread Zhenghua Lyu
Hi, I run TPC-DS benchmark for Postgres and find the join size estimation has several problems. For example, Ndistinct is key to join selectivity's estimation, this value does not take restrictions of the rel, I hit some cases in the function eqjoinsel, nd is much larger than vardata