Re: Proper usage of ndistinct vs. dependencies extended statistics

2019-04-10 Thread David Rowley
On Thu, 11 Apr 2019 at 11:53, Paul Martinez wrote: > > I have some questions about the different types of extended statistics > that were introduced in Postgres 10. > - Which types of queries are each statistic type supposed to improve? Multivariate ndistinct stats are aimed to improve distinct e

Proper usage of ndistinct vs. dependencies extended statistics

2019-04-10 Thread Paul Martinez
Hello, I have some questions about the different types of extended statistics that were introduced in Postgres 10. - Which types of queries are each statistic type supposed to improve? - When should one type of statistic be used over the other? Should they both always be used? We have a multi-t