Re: [PATCH] ltree hash functions

Tommy Pavlicek <tommypav122@gmail.com>

From: Tommy Pavlicek <tommypav122@gmail.com>
To: jian he <jian.universality@gmail.com>
Cc: daniel@yesql.se, Tomas Vondra <tomas.vondra@enterprisedb.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@lists.postgresql.org
Date: 2023-12-01T00:44:40Z
Lists: pgsql-hackers

Attachments

On Tue, Nov 28, 2023 at 7:38 PM jian he <jian.universality@gmail.com> wrote:
> you only change Makefile, you also need to change contrib/ltree/meson.build?
> Do you need to use EXPLAIN to demo the index usage?

Thanks! Yes, I missed the Meson build file. I added additional
commands with EXPLAIN (COSTS OFF) as I found in other places.

Patch updated for those comments (and a touch of cleanup in the tests) attached.

Commits

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

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