| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com> |
| Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: extended statistics n-distinct on multiple columns not used when join two tables |
| Date: | 2023-06-13 09:29:49 |
| Message-ID: | CAFj8pRCNu82ZCb4tMg9sCrZSqiLob84zfv+y38M1F7XaJEJFZA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Hi
út 13. 6. 2023 v 11:21 odesílatel James Pang (chaolpan) <chaolpan(at)cisco(dot)com>
napsal:
> 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.
>
There is not any support for multi tables statistic
Regards
Pavel
>
>
> Thanks,
>
>
>
> James
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2023-06-13 09:33:40 | Re: Views no longer in rangeTabls? |
| Previous Message | James Pang (chaolpan) | 2023-06-13 09:21:25 | extended statistics n-distinct on multiple columns not used when join two tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2023-06-13 11:25:53 | Re: extended statistics n-distinct on multiple columns not used when join two tables |
| Previous Message | James Pang (chaolpan) | 2023-06-13 09:21:25 | extended statistics n-distinct on multiple columns not used when join two tables |