Re: Reduce build times of pg_trgm GIN indexes

From:	David Geier <geidav(dot)pg(at)gmail(dot)com>
To:	Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Cc:	Japin Li <japinli(at)hotmail(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Reduce build times of pg_trgm GIN indexes
Date:	2026-10-23 07:53:26
Message-ID:	25e5a1da-44c9-427a-b9f9-65aac16d9a30@gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2026-01-05 15:01:44 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎  2026-01-06 17:00:23 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>   2026-01-06 20:05:45 from Kirill Reshke <reshkekirill(at)gmail(dot)com>    2026-01-09 12:10:38 from David Geier <geidav(dot)pg(at)gmail(dot)com>   2026-01-09 12:06:42 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎    2026-01-09 18:36:26 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi> 📎     2026-01-09 21:02:01 from David Geier <geidav(dot)pg(at)gmail(dot)com>      2026-01-14 12:27:05 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎    2026-01-12 22:10:03 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>     2026-01-21 15:45:06 from David Geier <geidav(dot)pg(at)gmail(dot)com>      2026-01-21 20:50:54 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>       2026-01-23 10:18:56 from David Geier <geidav(dot)pg(at)gmail(dot)com>        2026-03-02 12:17:56 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎         2026-03-03 17:31:51 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎          2026-04-07 11:27:40 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>           2026-04-08 02:15:38 from John Naylor <johncnaylorls(at)gmail(dot)com>            2026-04-13 15:05:30 from David Geier <geidav(dot)pg(at)gmail(dot)com>             2026-04-14 13:05:51 from David Geier <geidav(dot)pg(at)gmail(dot)com>           2026-04-09 11:28:24 from Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com> 📎            2026-04-13 09:41:02 from Peter Eisentraut <peter(at)eisentraut(dot)org>             2026-04-13 11:04:09 from Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com> 📎              2026-04-13 15:03:11 from David Geier <geidav(dot)pg(at)gmail(dot)com>               2026-04-13 17:15:52 from Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>                2026-04-14 09:22:27 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>           2026-04-12 18:05:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2026-04-13 15:22:10 from David Geier <geidav(dot)pg(at)gmail(dot)com>            2026-04-13 16:14:23 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>             2026-04-14 07:02:10 from David Geier <geidav(dot)pg(at)gmail(dot)com>              2026-04-15 11:06:14 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>               2026-04-15 19:12:51 from Peter Eisentraut <peter(at)eisentraut(dot)org>                2026-04-15 21:25:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                 2026-04-16 08:45:55 from Peter Eisentraut <peter(at)eisentraut(dot)org>                  2026-04-16 09:49:38 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                   2026-04-16 14:37:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                    2026-04-16 17:30:51 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                     2026-04-16 17:47:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                      2026-04-17 19:21:41 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                       2026-04-22 21:11:51 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                  2026-04-16 14:43:04 from Andres Freund <andres(at)anarazel(dot)de>           2026-04-13 15:06:40 from David Geier <geidav(dot)pg(at)gmail(dot)com>            2026-04-14 14:24:10 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎             2026-04-22 21:26:56 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎              2026-09-01 11:05:23 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎               2026-09-01 15:21:13 from Japin Li <japinli(at)hotmail(dot)com>                2026-09-02 09:16:04 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                 2026-09-02 15:15:44 from Japin Li <japinli(at)hotmail(dot)com>                  2026-09-03 07:41:53 from David Geier <geidav(dot)pg(at)gmail(dot)com>                 2026-09-08 14:58:04 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                  2026-09-09 08:49:05 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                   2026-09-09 14:30:45 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                    2026-09-14 12:31:23 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                     2026-10-23 07:53:26 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v11-0001-Use-branchless-comparisons-in-btint4cmp-and-btin.patch	text/plain	2.5 KB
v11-0002-Use-radix-sort-to-extract-trigrams.patch	text/plain	4.8 KB
v11-0003-Replace-GIN-build-accumulator-RB-tree-with-a-has.patch	text/plain	17.0 KB

In response to

• Re: Reduce build times of pg_trgm GIN indexes at 2026-09-14 12:31:23 from David Geier

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	David Geier	2026-10-23 08:18:31	Re: Use correct collation in pg_trgm
Previous Message	Koshi Shibagaki (Fujitsu)	2026-10-23 07:34:27	[PATCH] Support casts from numeric to oid8