Parallel CREATE INDEX for GIN indexes

Edit
ID 4966
Title Parallel CREATE INDEX for GIN indexes
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +7−0, All patches: +7−0
Tags Performance
Created 2024-05-02 15:20:57
Last modified 2026-02-04 09:38:32 (yesterday)
Latest email 2025-05-02 21:15:52 (9 months ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Committed
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
Target version
Authors Tomas Vondra (fuzzycz)
Reviewers Kirill Reshke (reshke), Matthias van de Meent (mmeent), Andy Fan (andy2)Become reviewer
Committer Tomas Vondra (fuzzycz)
Links
Emails
Parallel CREATE INDEX for GIN indexes
First at 2024-05-02 15:19:03 by Tomas Vondra <tomas.vondra at enterprisedb.com>
Latest at 2025-05-02 21:15:52 by Tomas Vondra <tomas at vondra.me>
Latest attachment (v1-0001-Fix-memory-leak-in-_gin_parallel_merge.patch) at 2025-04-18 01:03:07 from Vinod Sridharan <vsridh90 at gmail.com>
    Attachment (v1-0001-Fix-memory-leak-in-_gin_parallel_merge.patch) at 2025-04-18 01:03:07 from Vinod Sridharan <vsridh90 at gmail.com> (Patch: Yes)
    Attachment (v20250307-0004-Make-Gin-parallel-builds-use-a-single-tupl.patch) at 2025-03-07 02:08:10 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v20250304-0001-Use-a-single-GIN-tuplesort.patch) at 2025-03-04 19:50:43 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250303-0001-Compress-TID-lists-when-writing-GIN-tuples.patch) at 2025-03-03 16:16:34 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (poc-gin-build-hashing.patch) at 2025-02-26 20:08:39 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250225-0001-Allow-parallel-CREATE-INDEX-for-GIN-indexe.patch) at 2025-02-25 15:49:03 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250220-0001-Allow-parallel-CREATE-INDEX-for-GIN-indexe.patch) at 2025-02-20 16:56:02 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (ryzen-temporary-mb.pdf) at 2025-02-19 21:54:16 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (v20250217-0001-Allow-parallel-CREATE-INDEX-for-GIN-indexe.patch) at 2025-02-17 14:56:51 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250216-0001-Allow-parallel-CREATE-INDEX-for-GIN-indexe.patch) at 2025-02-16 03:47:10 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250107-0001-Allow-parallel-create-for-GIN-indexes.patch) at 2025-01-07 11:59:03 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20250104-0001-Allow-parallel-create-for-GIN-indexes.patch) at 2025-01-04 16:58:36 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (v20241008-0001-Allow-parallel-create-for-GIN-indexes.patch) at 2024-10-08 12:06:21 from Tomas Vondra <tomas at vondra.me> (Patch: Yes)
    Attachment (gin-parallel-builds.pdf) at 2024-07-12 15:34:25 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (v20240705-0003-Remove-the-explicit-pg_qsort-in-workers.patch) at 2024-07-05 19:45:31 from Matthias van de Meent <boekewurm+postgres at gmail.com> (Patch: Yes)
    Attachment (v20240702-0001-Add-function-normal_rand_array-function-to.patch) at 2024-07-02 00:07:57 from Andy Fan <zhihuifan1213 at 163.com> (Patch: Yes)
    Attachment (v20240624-0001-Allow-parallel-create-for-GIN-indexes.patch) at 2024-06-24 00:58:16 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20240620-0001-Allow-parallel-create-for-GIN-indexes.patch) at 2024-06-20 21:19:43 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20240619-0001-Allow-parallel-create-for-GIN-indexes.patch) at 2024-06-19 11:55:35 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v20240505-0001-Allow-parallel-create-for-GIN-indexes.patch) at 2024-05-05 18:49:03 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (gin-parallel-absolute.png) at 2024-05-02 15:19:03 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
History
When Who What
2026-02-04 09:38:32 Álvaro Herrera (alvherre) Closed in commitfest PG19-1 with status: Committed
2026-02-04 09:38:32 Álvaro Herrera (alvherre) Changed committer to fuzzycz
2026-01-17 11:54:35 Kirill Reshke (reshke) Added reshke as reviewer
2025-04-09 10:47:21 Kirill Reshke (reshke) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-03 16:31:48 CFbot Patch does not need rebase anymore
2025-02-26 20:31:43 CFbot Patch needs rebase
2025-02-06 22:06:15 Tomas Vondra (fuzzycz) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-01 12:48:50 Kirill Reshke (reshke) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-08 02:03:46 Michael Paquier (michael-kun) New status: Waiting on Author
2024-10-08 02:01:36 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 04:47:53 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-06-22 01:44:43 Andy Fan (andy2) Added andy2 as reviewer
2024-05-03 15:43:33 Matthias van de Meent (mmeent) Added mmeent as reviewer
2024-05-02 15:21:12 Tomas Vondra (fuzzycz) Changed authors to Tomas Vondra (fuzzycz)
2024-05-02 15:20:58 Tomas Vondra (fuzzycz) Attached mail thread 6ab4003f-a8b8-4d75-a67f-f25ad98582dc@enterprisedb.com
2024-05-02 15:20:57 Tomas Vondra (fuzzycz) Created patch record
Edit