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

Поиск
Список
Период
Сортировка
От James Pang (chaolpan)
Тема extended statistics n-distinct on multiple columns not used when join two tables
Дата
Msg-id PH0PR11MB519189611860A0F7FDE53509D655A@PH0PR11MB5191.namprd11.prod.outlook.com
обсуждение исходный текст
Ответы Re: extended statistics n-distinct on multiple columns not used when join two tables
Список pgsql-performance

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

      

Вложения

В списке pgsql-performance по дате отправления: