Subject: extended statistics n-distinct on multiple columns not used when join two tables

From: "James Pang (chaolpan)" <[email-masked]>
Date: Tue, 13 Jun 2023 09:21:25 +0000

Hi,
     When join two table on multiple columns equaljoin, rows estimation always use selectivity = multiplied by distinct multiple individual columns, possible to use  extended n-distinct statistics on multiple columns?
    PG v14.8-1, attached please check test case with details.

Thanks,

James