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: v6, Patch count: 2, First patch: +2−6, All patches: +53−14
Tags Performance
Created 2026-01-21 09:38:09
Last modified 2026-04-10 00:00:04 (5 days ago)
Latest email 2026-04-15 11:06:14 (7 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
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-15 11:06:14 by Heikki Linnakangas <hlinnaka at iki.fi>
Latest attachment (v6-0002-Optimize-generate_trgm-with-radix-sort.patch) at 2026-04-14 14:24:10 from David Geier <geidav.pg at gmail.com>
    Attachment (v6-0002-Optimize-generate_trgm-with-radix-sort.patch) at 2026-04-14 14:24:10 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v2-0001-gin-change-remaining-StaticAssertStmt-to-StaticAs.patch) at 2026-04-13 11:04:09 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0001-gin-change-remaining-StaticAssertStmt-to-StaticAs.patch) at 2026-04-09 11:28:24 from Bertrand Drouvot <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    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-10 00:00:04 CFbot Moved from CF PG19-Final to CF PG20-1
2026-04-09 11:44:29 CFbot Patch does not need rebase anymore
2026-04-08 18:05:31 CFbot Patch needs rebase
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