Horton

Optimize sorting and deduplicating trigrams

Heikki Linnakangas <heikki.linnakangas@iki.fi>

View on postgr.es
Commit: 9f3755ea07aa8858999bdac3d33151e93d2643e2
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2026-04-07T11:11:25Z
Releases: 19 (unreleased) 
Optimize sorting and deduplicating trigrams

Use templated qsort() so that the comparison function can be
inlined. To speed up qunique(), use a specialized comparison function
that only checks for equality.

Author: David Geier <geidav.pg@gmail.com>
Reviewed-by: Kirill Reshke <reshkekirill@gmail.com>
Discussion: https://www.postgresql.org/message-id/2a76b5ef-4b12-4023-93a1-eed6e64968f3@gmail.com

Files

PathChange+/−
contrib/pg_trgm/trgm_op.c modified +53 −10

Discussion