Reduce build times of pg_trgm GIN indexes

Edit
ID 6418
Title Reduce build times of pg_trgm GIN indexes
CI (CFBot) Needs rebase! Needs rebase since 7 hours. Failing since 3 weeks.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Performance
Created 2026-01-21 09:38:09
Last modified 2026-01-21 09:38:09 (3 weeks ago)
Latest email 2026-01-23 10:18:56 (2 weeks ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
Target version 19
Authors David Geier (geidav)
Reviewers Become reviewer
Committer
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-01-23 10:18:56 by David Geier <geidav.pg at gmail.com>
Latest attachment (table_with_random_int_arrays.sql) at 2026-01-14 12:27:05 from David Geier <geidav.pg at gmail.com>
    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-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