Reduce build times of pg_trgm GIN indexes

Edit
ID 6418
Title Reduce build times of pg_trgm GIN indexes
CI (CFBot) Summary
Stats (from CFBot) Patch version: v5, Patch count: 5, First patch: +66−88, All patches: +148−104
Tags Performance
Created 2026-01-21 09:38:09
Last modified 2026-04-07 11:28:12 (yesterday)
Latest email 2026-04-08 02:15:38 (15 hours ago)
Status
PG19-Final (2026-03-01 – 2026-04-09): Needs review
Target version 19
Authors David Geier (geidav)
Reviewers Heikki Linnakangas (heikki)Become reviewer
Committer Heikki Linnakangas (heikki)
Links
Emails
Reduce build times of pg_trgm GIN indexes
First at 2026-01-05 15:01:44 by David Geier <geidav.pg at gmail.com>
Latest at 2026-04-08 02:15:38 by John Naylor <johncnaylorls at gmail.com>
Latest attachment (v5-0005-Optimize-generate_trgm-with-radix-sort.patch) at 2026-03-03 17:31:51 from David Geier <geidav.pg at gmail.com>
    Attachment (v5-0005-Optimize-generate_trgm-with-radix-sort.patch) at 2026-03-03 17:31:51 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v4-0005-Optimize-generate_trgm-with-radix-sort.patch) at 2026-03-02 12:17:56 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (table_with_random_int_arrays.sql) at 2026-01-14 12:27:05 from David Geier <geidav.pg at gmail.com> (Patch: No)
    Attachment (0001-Make-the-deduplication-in-ginExtractEntries-a-little.patch) at 2026-01-09 18:36:26 from Heikki Linnakangas <hlinnaka at iki.fi> (Patch: Yes)
    Attachment (v2-0008-Add-ASCII-fastpath-to-generate_trgm_only.patch) at 2026-01-09 12:06:42 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0008-Add-ASCII-fastpath-to-generate_trgm_only.patch) at 2026-01-05 15:01:44 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
History
When Who What
2026-04-07 11:28:12 Heikki Linnakangas (heikki) Added heikki as committer
2026-04-07 09:21:19 Heikki Linnakangas (heikki) Added heikki as reviewer
2026-03-02 12:47:50 CFbot Patch does not need rebase anymore
2026-02-11 05:06:28 CFbot Patch needs rebase
2026-01-21 09:38:09 David Geier (geidav) Attached mail thread 5d366878-2007-4d31-861e-19294b7a583b@gmail.com
2026-01-21 09:38:09 David Geier (geidav) Created patch record
Edit