On Thu, Apr 10, 2025 at 3:37 AM Robins Tharakan wrote:
> On Mon, 10 Mar 2025 at 22:18, Alexander Korotkov
> wrote:
> >
> > Use extended stats for precise estimation of bucket size in hash join
>
>
> After this commit, I see a recurrence of an error similar to the one fixed in
> e28033fe1af8037e
Hi,
On Mon, 10 Mar 2025 at 22:18, Alexander Korotkov
wrote:
>
> Use extended stats for precise estimation of bucket size in hash join
After this commit, I see a recurrence of an error similar to the one fixed
in e28033fe1af8037e0fec8bb3a32fabbe18ac06b1
https://www.postgresql.org/message-id/188
Use extended stats for precise estimation of bucket size in hash join
Recognizing the real-life complexity where columns in the table often have
functional dependencies, PostgreSQL's estimation of the number of distinct
values over a set of columns can be underestimated (or much rarely,
overestima
