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
