| From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
|---|---|
| To: | Ancoron Luciferis <ancoron(dot)luciferis(at)googlemail(dot)com> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Custom opclass for column statistics? |
| Date: | 2019-07-06 13:38:58 |
| Message-ID: | 20190706133858.n7lj4wrte6ulcvk3@development |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-07-06 13:58:58 | Re: Custom opclass for column statistics? |
| Previous Message | Ancoron Luciferis | 2019-07-06 09:02:27 | Custom opclass for column statistics? |