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

Edit
ID 7401
Title gist_trgm_ops '=' operator: planner picks it over btree, ~300x slower
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +127−5, All patches: +127−5
Tags Performance
Created 2026-10-06 11:05:43
Last modified 2026-10-06 11:05:43 (46 minutes ago)
Latest email 2026-10-06 11:02:33 (49 minutes ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version 20
Authors Vaibhav Dalvi (vaibhavdalvi)
Reviewers Become reviewer
Committer
Links
Emails
gist_trgm_ops '=' operator: planner picks it over btree, ~300x slower
First at 2026-09-02 11:11:31 by Vaibhav Dalvi <vaibhav.dalvi at enterprisedb.com>
Latest at 2026-10-06 11:02:33 by Vaibhav Dalvi <vaibhav.dalvi at enterprisedb.com>
Latest attachment (v1-0001-Add-gist_trgm_ops_noeq.patch) at 2026-10-06 11:02:33 from Vaibhav Dalvi <vaibhav.dalvi at enterprisedb.com>
    Attachment (v1-0001-Add-gist_trgm_ops_noeq.patch) at 2026-10-06 11:02:33 from Vaibhav Dalvi <vaibhav.dalvi at enterprisedb.com> (Patch: No)
    Attachment (v1-0001-Add-gist_trgm_ops_noeq.patch) at 2026-09-02 11:11:31 from Vaibhav Dalvi <vaibhav.dalvi at enterprisedb.com> (Patch: No)
History
When Who What
2026-10-06 11:05:43 Vaibhav Dalvi (vaibhavdalvi) Attached mail thread CA+vB=AHon6EB=90pbPDik_u8+++Ty8TA6Z4-RXo_X5QCr71kcQ@mail.gmail.com
2026-10-06 11:05:43 Vaibhav Dalvi (vaibhavdalvi) Created patch record
Edit