Reduce build times of pg_trgm GIN indexes

Title

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-01-21 09:38:09 (1 month ago)

Latest email

2026-03-03 17:31:51 (5 hours ago)

Status

PG19-Final (2026-03-01 – 2026-03-31): Needs review

Target version

Authors

David Geier (geidav)

Reviewers

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-03-03 17:31:51 by David Geier <geidav.pg 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-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