Postgres Pro
Downloads
Home   >   mailing lists

extended statistics n-distinct on multiple columns not used when join two tables - Mailing list pgsql-performance

From James Pang (chaolpan)
Subject extended statistics n-distinct on multiple columns not used when join two tables
Date
Msg-id PH0PR11MB519189611860A0F7FDE53509D655A@PH0PR11MB5191.namprd11.prod.outlook.com
Whole thread Raw
Responses Re: extended statistics n-distinct on multiple columns not used when join two tables  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-performance
Tree view

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

      

Attachment

pgsql-performance by date:

Previous
From: Chris Hoover
Date:
Subject: Re: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT
Next
From: Pavel Stehule
Date:
Subject: Re: extended statistics n-distinct on multiple columns not used when join two tables