Re: Custom base type and suboptimal query plans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ayo <ayo(at)blicky(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Custom base type and suboptimal query plans
Date: 2021-02-23 17:47:50
Message-ID: 3875364.1614102470@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ayo <ayo(at)blicky(dot)net> writes:
> No luck. It uses the index now, but seemingly only to loop over it. The
> integer version uses a HashAggregate, I must have missed something in my
> implementation to make the planner avoid that node. Does it have any special
> type requirements, other than the hash operator class?

Hmm ... did you remember to set the oprcanhash property on the equality
operator?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ayo 2021-02-23 18:07:03 Re: Custom base type and suboptimal query plans
Previous Message Ayo 2021-02-23 17:43:37 Re: Custom base type and suboptimal query plans