Re: pg_stats and range statistics - Mailing list pgsql-hackers

From jian he
Subject Re: pg_stats and range statistics
Date
Msg-id CACJufxGM427O9SDvHg0a+KNXMrraq0JG+nFzgST8rAjdd62hQQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_stats and range statistics  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: pg_stats and range statistics  (Alexander Korotkov <aekorotkov@gmail.com>)
List pgsql-hackers
On Sat, Nov 25, 2023 at 7:06 AM Alexander Korotkov <aekorotkov@gmail.com> wrote:
>
> Hi!
> Additionally, I found that the current patch can't handle infinite
> range bounds and discards information about inclusiveness of range
> bounds.  The infinite bounds could be represented as NULL (while I'm
> not sure how good this representation is).  Regarding inclusiveness, I
> don't see the possibility to represent them in a reasonable way within
> an array of base types.  I also don't feel good about discarding the
> accuracy in the pg_stats view.
>

in range_length_histogram, maybe we can document that when calculating
the length of a range, inclusiveness will be true.



pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: pg_stats and range statistics
Next
From: Egor Rogov
Date:
Subject: Re: pg_stats and range statistics