Re: Parallel CREATE INDEX for GIN indexes

From:	Tomas Vondra <tomas(at)vondra(dot)me>
To:	Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Cc:	Kirill Reshke <reshkekirill(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Parallel CREATE INDEX for GIN indexes
Date:	2025-03-04 19:50:43
Message-ID:	fd7710b1-50bd-4e61-b735-7178be6ab771@vondra.me
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2024-05-02 15:19:03 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎  2024-05-02 17:12:27 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>   2024-05-02 18:22:23 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>    2024-05-05 18:49:03 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎    2024-05-09 09:44:49 from Andy Fan <zhihuifan1213(at)163(dot)com>     2024-05-09 13:13:16 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>      2024-05-09 15:51:30 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>       2024-05-09 19:26:04 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>      2024-05-10 05:53:27 from Andy Fan <zhihuifan1213(at)163(dot)com>       2024-05-10 11:29:12 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>    2024-05-09 14:28:36 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>  2024-05-09 10:14:40 from Andy Fan <zhihuifan1213(at)163(dot)com>   2024-05-09 12:19:23 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>    2024-05-13 08:19:43 from Andy Fan <zhihuifan1213(at)163(dot)com>     2024-05-13 09:19:08 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>      2024-05-28 09:29:48 from Andy Fan <zhihuifan1213(at)163(dot)com>       2024-06-19 11:55:35 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎        2024-06-20 21:19:43 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎         2024-06-24 00:58:16 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎          2024-07-02 00:07:57 from Andy Fan <zhihuifan1213(at)163(dot)com> 📎           2024-07-02 15:11:52 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>            2024-07-09 01:18:11 from Andy Fan <zhihuifan1213(at)163(dot)com>             2024-08-02 15:37:17 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>          2024-07-03 18:36:26 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>           2024-07-05 19:45:31 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> 📎            2024-07-07 16:26:03 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>             2024-07-08 09:45:55 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>              2024-07-08 11:38:50 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>               2024-07-08 15:35:42 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                2024-07-12 15:34:25 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> 📎                 2024-08-27 10:14:46 from Andy Fan <zhihuifan1213(at)163(dot)com>                  2024-08-27 11:16:25 from Tomas Vondra <tomas(at)vondra(dot)me>                   2024-08-29 04:30:44 from Andy Fan <zhihuifan1213(at)163(dot)com>                  2024-08-27 13:28:12 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                   2024-08-28 00:37:55 from Andy Fan <zhihuifan1213(at)163(dot)com>                    2024-08-28 01:15:33 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                 2024-10-08 02:03:34 from Michael Paquier <michael(at)paquier(dot)xyz>                  2024-10-08 12:06:21 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                   2024-11-24 18:04:38 from Kirill Reshke <reshkekirill(at)gmail(dot)com>                    2025-01-04 16:58:36 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                     2025-01-06 19:13:43 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                      2025-01-07 11:59:03 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                       2025-02-12 14:59:08 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                        2025-02-12 17:52:50 from Tomas Vondra <tomas(at)vondra(dot)me>                         2025-02-16 03:47:10 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                          2025-02-17 13:01:09 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                           2025-02-17 14:56:51 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                            2025-02-19 21:54:16 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                             2025-02-20 16:56:02 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                              2025-02-25 15:49:03 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                               2025-02-26 20:08:39 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                                2025-03-03 16:16:34 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                                 2025-03-04 19:50:43 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                                  2025-03-07 02:08:10 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> 📎                                   2025-03-15 09:24:32 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                  2025-03-09 16:38:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                   2025-03-09 22:17:29 from Tomas Vondra <tomas(at)vondra(dot)me>                                    2025-03-09 22:23:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                     2025-03-09 22:27:53 from Peter Geoghegan <pg(at)bowt(dot)ie>                                  2025-04-02 16:43:46 from Andres Freund <andres(at)anarazel(dot)de>                                   2025-04-02 16:49:33 from Tomas Vondra <tomas(at)vondra(dot)me>                                    2025-04-09 10:48:08 from Kirill Reshke <reshkekirill(at)gmail(dot)com>                        2025-02-16 04:02:16 from Tomas Vondra <tomas(at)vondra(dot)me>                       2026-01-11 20:31:07 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                        2026-01-11 22:20:46 from Tomas Vondra <tomas(at)vondra(dot)me>                         2026-01-15 05:08:37 from Kirill Reshke <reshkekirill(at)gmail(dot)com>                          2026-01-16 18:03:47 from Tomas Vondra <tomas(at)vondra(dot)me> 📎                           2026-01-16 18:43:47 from Kirill Reshke <reshkekirill(at)gmail(dot)com>                            2026-01-16 19:07:10 from Tomas Vondra <tomas(at)vondra(dot)me>                             2026-01-17 11:32:30 from Kirill Reshke <reshkekirill(at)gmail(dot)com>                           2026-01-26 23:33:55 from Tomas Vondra <tomas(at)vondra(dot)me>           2024-07-07 16:10:49 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>            2024-07-08 08:05:38 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>            2025-04-18 01:03:07 from Vinod Sridharan <vsridh90(at)gmail(dot)com> 📎             2025-04-21 09:49:06 from Tomas Vondra <tomas(at)vondra(dot)me>             2025-04-30 12:39:08 from Tomas Vondra <tomas(at)vondra(dot)me>              2025-05-02 21:15:52 from Tomas Vondra <tomas(at)vondra(dot)me>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v20250304-0001-Use-a-single-GIN-tuplesort.patch	text/x-patch	32.2 KB
v20250304-0002-WIP-parallel-inserts-into-GIN-index.patch	text/x-patch	18.4 KB

In response to

• Re: Parallel CREATE INDEX for GIN indexes at 2025-03-03 16:16:34 from Tomas Vondra

Responses

• Re: Parallel CREATE INDEX for GIN indexes at 2025-03-07 02:08:10 from Matthias van de Meent
• Re: Parallel CREATE INDEX for GIN indexes at 2025-03-09 16:38:49 from Tom Lane
• Re: Parallel CREATE INDEX for GIN indexes at 2025-04-02 16:43:46 from Andres Freund

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Nathan Bossart	2025-03-04 20:01:28	Re: Clarification on Role Access Rights to Table Indexes
Previous Message	Jeff Davis	2025-03-04 19:48:54	Re: Make tuple deformation faster