Horton

Re: [PATCH] ltree hash functions

Tommy Pavlicek <tommypav122@gmail.com>

View thread View on postgr.es
From: Tommy Pavlicek <tommypav122@gmail.com>
To: daniel@yesql.se
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@lists.postgresql.org
Date: 2023-11-28T22:08:44Z
Lists: pgsql-hackers

Attachments

On Thu, Jul 6, 2023 at 2:18 AM Daniel Gustafsson <daniel@yesql.se> wrote:
>
> > On 19 Jun 2023, at 11:18, Tommy Pavlicek <tommypav122@gmail.com> wrote:
>
> > Tommy, are you interested in extending ALTER OPERATOR to allow this,
> > which would also allow fixing the ltree operator?
> >
> > Yes, I can do that. I took a look over the code and email thread and it seems like it should be relatively straight forward. I'll put a patch together for that and then update this patch to alter the operator.
>
> Did you have a chance to look at this for an updated patch for this commitfest?

I finally had a chance to look at this and I've updated the patch to
alter the = operator to enable hash joins.

This is ready to be looked at now.

Is there anything I need to do to move this forward?

Cheers,
Tommy

Commits

  1. Add hash support functions and hash opclass for contrib/ltree.

  2. Add ALTER OPERATOR command, for changing selectivity estimator functions.