Custom opclass for column statistics?

Поиск
Список
Период
Сортировка
От Ancoron Luciferis
Тема Custom opclass for column statistics?
Дата
Msg-id b0590dd1-5bfb-ad62-c4d0-a7057c04a68b@googlemail.com
обсуждение исходный текст
Ответы Re: Custom opclass for column statistics?  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: Custom opclass for column statistics?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Perplexing, regular decline in performance
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Custom opclass for column statistics?