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 18:23:45
Message-ID: 3877235.1614104625@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ayo <ayo(at)blicky(dot)net> writes:
> Aaah! That was it, I had totally missed the HASHES and MERGES options to
> CREATE OPERATOR. It works perfectly now that I set those.

Cool.

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

No, they just flag that the operator is equality in some hash or btree
(respectively) opclass.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-02-23 18:40:11 Re: pg_restore - generated column - not populating
Previous Message Santosh Udupi 2021-02-23 18:18:52 Re: pg_restore - generated column - not populating