Re: gist_trgm_ops '=' operator: planner picks it over btree, ~300x slower

From: Alexander Nestorov <alexandernst(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>, Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Vaibhav Dalvi <vaibhav(dot)dalvi(at)enterprisedb(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org, dgrowleyml(at)gmail(dot)com <dgrowleyml(at)gmail(dot)com>
Subject: Re: gist_trgm_ops '=' operator: planner picks it over btree, ~300x slower
Date: 2026-09-03 07:40:54
Message-ID: e0f24009-f051-47b2-895a-b9c7bd617d59@Spark
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Good morning!

I wanted to make you aware that there is a patchset that you might find interesting for this topic:
https://www.postgresql.org/message-id/36b4f67d-5975-452c-a6b8-b6407f0924ee%40Spark

Regards

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Geier 2026-09-03 07:41:53 Re: Reduce build times of pg_trgm GIN indexes
Previous Message Hayato Kuroda (Fujitsu) 2026-09-03 07:33:18 RE: Fix resource leak in FindConflictTuple() retry path