Re: Custom opclass for column statistics?

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: Custom opclass for column statistics?
Дата
Msg-id 20190706133858.n7lj4wrte6ulcvk3@development
обсуждение исходный текст
Ответ на Custom opclass for column statistics?  (Ancoron Luciferis <ancoron.luciferis@googlemail.com>)
Ответы Re: Custom opclass for column statistics?  (Ancoron Luciferis <ancoron.luciferis@googlemail.com>)
Список 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 



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

Предыдущее
От: Ancoron Luciferis
Дата:
Сообщение: Custom opclass for column statistics?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Custom opclass for column statistics?