Custom opclass for column statistics?

From: Ancoron Luciferis <ancoron(dot)luciferis(at)googlemail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Custom opclass for column statistics?
Date: 2019-07-06 09:02:27
Message-ID: b0590dd1-5bfb-ad62-c4d0-a7057c04a68b@googlemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Thanx and Cheers,

Ancoron

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2019-07-06 13:38:58 Re: Custom opclass for column statistics?
Previous Message Justin Pryzby 2019-06-27 00:24:42 Re: Perplexing, regular decline in performance