Re: Custom base type and suboptimal query plans

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

On 2021-02-23, Tom Lane wrote:
> Hmm ... did you remember to set the oprcanhash property on the equality
> operator?

Aaah! That was it, I had totally missed the HASHES and MERGES options to
CREATE OPERATOR. It works perfectly now that I set those.

Do those options make sense for other operators besides equality, too?

Many thanks for the help.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Santosh Udupi 2021-02-23 18:18:52 Re: pg_restore - generated column - not populating
Previous Message Tom Lane 2021-02-23 17:47:50 Re: Custom base type and suboptimal query plans