Re: Custom opclass for column statistics? - Mailing list pgsql-performance

On Sat, Jul 06, 2019 at 11:02:27AM +0200, Ancoron Luciferis wrote:
>Hi,
>
>I've been wondering whether it is possible somehow to have the standard
>column statistics to respect a certain operator class?
>
>The reason why I am asking for this is that I have a UUID column with a
>unique index at it using a custom operator class which implies a
>different sort order than for the default UUID operator class.
>
>This results into planner mistakes when determining whether to use the
>index for row selection or not. Too often it falls back into sequential
>scan due to this.
>

Can you share an example demonstrating the issue?


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services