VCI (columnar store extension)

Edit
ID 5829
Title VCI (columnar store extension)
CI (CFBot) Summary
Stats (from CFBot) Patch version: v20260210, Patch count: 9, First patch: +577−44, All patches: +42650−45
Tags
Created 2025-06-19 05:40:03
Last modified 2026-03-02 05:38:36 (1 month ago)
Latest email 2026-02-17 17:32:49 (1 month ago)
Status
PG20-Drafts (2026-03-01 – 2027-02-28): Needs review
PG19-Drafts (2025-06-22 – 2026-02-28): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
Target version
Authors Aya Iwata (iwata.aya), Peter Smith (smithpb2250)
Reviewers Become reviewer
Committer
Links Wiki
Emails
[WIP]Vertical Clustered Index (columnar store extension) - take2
First at 2024-10-07 14:53:19 by "Aya Iwata (Fujitsu)" <iwata.aya at fujitsu.com>
Latest at 2026-02-17 17:32:49 by Álvaro Herrera <alvherre at kurilemu.de>
Latest attachment (v20260210-0001-VCI-changes-to-postgres-core.patch) at 2026-02-10 08:02:53 from Peter Smith <smithpb2250 at gmail.com>
    Attachment (v20260210-0001-VCI-changes-to-postgres-core.patch) at 2026-02-10 08:02:53 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20260205-0002-VCI-main-part1.patch) at 2026-02-04 22:50:11 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20260203-0001-VCI-changes-to-postgres-core.patch) at 2026-02-03 05:14:14 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20260202-0003-VCI-main-part2.patch) at 2026-02-02 04:44:55 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20260129-0003-VCI-main-part2.patch) at 2026-01-29 01:18:28 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20260119-0001-VCI-changes-to-postgres-core.patch) at 2026-01-18 23:14:27 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20260116-0003-VCI-main-part2.patch) at 2026-01-16 03:01:30 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20251223-0001-VCI-changes-to-postgres-core.patch) at 2025-12-23 05:00:13 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20251219-0001-VCI-changes-to-postgres-core.patch) at 2025-12-19 02:19:47 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20251217-0001-VCI-changes-to-postgres-core.patch) at 2025-12-17 01:40:13 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20251209-0002-VCI-main-part1.patch) at 2025-12-09 05:41:30 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20251118-0003-VCI-module-documentation.patch) at 2025-11-17 22:45:39 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Fixed-WAL-record-in-cleanUpWos.patch) at 2025-11-17 14:32:34 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v20251117-0003-VCI-module-documentation.patch) at 2025-11-17 01:34:44 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20251114-0001-VCI-changes-to-postgres-core.patch) at 2025-11-14 04:24:11 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (vci_always_fail_update_delete_vector.patch) at 2025-11-12 16:11:51 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v20251106-0003-VCI-module-documentation.patch) at 2025-11-06 07:22:55 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v30-0001-VCI-changes-to-postgres-core.patch) at 2025-10-14 05:44:25 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v29-0001-VCI-changes-to-postgres-core.patch) at 2025-10-09 23:37:49 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v28-0003-VCI-module-documentation.patch) at 2025-10-06 02:11:59 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v27-0001-VCI-changes-to-postgres-core.patch) at 2025-09-28 23:39:12 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (startup_segfault_backtrace.txt) at 2025-09-26 14:09:32 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: No)
    Attachment (v26-0001-VCI-changes-to-postgres-core.patch) at 2025-09-25 01:49:16 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Avoid-VCI-sort-after-non-VCI-join-in-planner.patch) at 2025-09-24 13:47:37 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v25-0003-VCI-module-documentation.patch) at 2025-09-23 02:54:13 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Avoid-VCI-sort-after-non-VCI-join-in-planner.patch) at 2025-09-19 14:13:51 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v24-0001-VCI-changes-to-postgres-core.patch) at 2025-09-18 04:46:17 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Assert-corrrect-node-tags-when-casting-to-VciScanSta.patch) at 2025-09-17 15:15:00 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Fixed-set-but-not-used-clang-warnings.patch) at 2025-09-12 15:58:58 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v23-0001-VCI-changes-to-postgres-core.patch) at 2025-09-10 02:31:57 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-VCI-changes-to-postgres-core.patch) at 2025-09-09 01:41:44 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-VCI-changes-to-postgres-core.patch) at 2025-08-29 03:37:10 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v20-0003-VCI-module-documentation.patch) at 2025-08-28 00:20:36 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v19-0003-VCI-module-documentation.patch) at 2025-08-20 02:27:00 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Fixed-comment-and-guard-name-in-vci_pg_copy.h.patch) at 2025-08-15 17:45:10 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v18-0001-VCI-changes-to-postgres-core.patch) at 2025-08-14 01:23:34 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Removed-vci_set_merge_and_copy_trans_funcs.patch) at 2025-08-13 16:28:34 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v17-typos.diff) at 2025-08-12 03:48:20 from Japin Li <japinli at hotmail.com> (Patch: Yes)
    Attachment (v17-vci-partial-review.diff) at 2025-08-11 09:39:01 from Japin Li <japinli at hotmail.com> (Patch: Yes)
    Attachment (v17-0003-VCI-module-documentation.patch) at 2025-08-08 08:08:27 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v16-0003-VCI-module-documentation.patch) at 2025-08-01 08:24:25 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Restore-security-context-for-add_reindex_index_hook.patch) at 2025-07-31 08:20:00 from Japin Li <japinli at hotmail.com> (Patch: Yes)
    Attachment (v15-0003-VCI-module-documentation.patch) at 2025-07-28 20:57:54 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Initialize-HeapTupleFreeze-structure-prior-to-use.patch) at 2025-07-23 03:58:31 from Japin Li <japinli at hotmail.com> (Patch: Yes)
    Attachment (v14-0003-VCI-module-documentation.patch) at 2025-07-22 07:46:44 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-VCI-changes-to-postgres-core.patch) at 2025-07-17 03:22:17 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (README) at 2025-07-14 08:37:41 from Peter Smith <smithpb2250 at gmail.com> (Patch: No)
    Attachment (v12-0001-VCI-changes-to-postgres-core.patch) at 2025-07-11 06:31:04 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v11-0003-VCI-module-documentation.patch) at 2025-07-08 00:11:55 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v10-0003-VCI-module-documentation.patch) at 2025-07-02 06:23:25 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-VCI-changes-to-postgres-core.patch) at 2025-06-25 02:22:57 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Avoid-magic-numbers-in-vci_is_supported_type.patch) at 2025-06-19 18:09:27 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v8-0003-VCI-module-documentation.patch) at 2025-06-19 04:14:16 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v7-0005-VCI-module-documentation.patch) at 2025-06-16 03:48:06 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-VCI-changes-to-postgres-core.patch) at 2025-06-12 07:06:19 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (README-20250610) at 2025-06-10 22:22:46 from Peter Smith <smithpb2250 at gmail.com> (Patch: No)
    Attachment (v5-0004-VCI-module-ENABLE_WOSROS_TRANS_DEFERRAL-co.patch) at 2025-06-10 08:02:04 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (0001-Removed-unnecessary-preload-libraries-checks.patch) at 2025-06-04 13:47:31 from Timur Magomedov <t.magomedov at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0003-VCI-documentation.patch) at 2025-05-29 08:08:20 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v3-0003-VCI-documentation.patch) at 2025-05-26 05:07:25 from Peter Smith <smithpb2250 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-postgres-code-fix-needed-for-VCI.patch) at 2025-05-13 01:08:34 from "Aya Iwata (Fujitsu)" <iwata.aya at fujitsu.com> (Patch: Yes)
    Attachment (0001-Add-postgres-code-fix-needed-for-VCI.patch) at 2025-05-09 10:08:26 from "Aya Iwata (Fujitsu)" <iwata.aya at fujitsu.com> (Patch: No)
History
When Who What
2026-04-03 08:37:08 Xu Jiajun (xuj) Removed xuj from reviewers
2026-04-03 08:37:04 Xu Jiajun (xuj) Added xuj as reviewer
2026-03-02 05:38:36 Hayato Kuroda (ha-kun) Moved from CF PG19-Drafts to CF PG20-Drafts
2026-02-21 11:05:42 CFbot Patch does not need rebase anymore
2026-02-19 16:18:33 CFbot Patch needs rebase
2026-02-15 22:43:43 CFbot Patch does not need rebase anymore
2026-02-14 12:43:31 CFbot Patch needs rebase
2026-02-10 21:46:43 CFbot Patch does not need rebase anymore
2026-02-10 09:05:37 CFbot Patch needs rebase
2026-02-10 00:56:40 CFbot Patch does not need rebase anymore
2026-02-09 22:36:41 CFbot Patch needs rebase
2025-12-28 17:20:30 CFbot Patch does not need rebase anymore
2025-12-26 22:10:24 CFbot Patch needs rebase
2025-12-22 04:53:33 CFbot Patch does not need rebase anymore
2025-12-19 06:42:30 CFbot Patch needs rebase
2025-12-17 21:11:32 CFbot Patch does not need rebase anymore
2025-12-17 12:41:28 CFbot Patch needs rebase
2025-11-28 01:43:31 CFbot Patch does not need rebase anymore
2025-11-24 00:00:30 CFbot Patch needs rebase
2025-11-19 21:42:32 CFbot Patch does not need rebase anymore
2025-11-16 04:07:23 CFbot Patch needs rebase
2025-11-14 06:38:34 CFbot Patch does not need rebase anymore
2025-11-12 16:33:24 CFbot Patch needs rebase
2025-11-10 22:59:32 CFbot Patch does not need rebase anymore
2025-11-07 09:02:31 CFbot Patch needs rebase
2025-11-06 21:24:31 CFbot Patch does not need rebase anymore
2025-11-02 10:41:48 CFbot Patch needs rebase
2025-10-21 09:50:42 CFbot Patch does not need rebase anymore
2025-10-19 14:11:26 CFbot Patch needs rebase
2025-10-17 13:49:33 CFbot Patch does not need rebase anymore
2025-10-16 03:42:24 CFbot Patch needs rebase
2025-10-11 23:47:28 CFbot Patch does not need rebase anymore
2025-10-07 10:30:26 CFbot Patch needs rebase
2025-10-02 03:45:42 CFbot Patch does not need rebase anymore
2025-09-26 14:45:23 CFbot Patch needs rebase
2025-09-25 09:00:09 Hayato Kuroda (ha-kun) Changed wikilink to https://wiki.postgresql.org/wiki/Vertical_clustered_index
2025-09-25 03:14:28 CFbot Patch does not need rebase anymore
2025-09-09 22:03:22 CFbot Patch needs rebase
2025-09-06 22:47:28 CFbot Patch does not need rebase anymore
2025-09-05 10:47:20 CFbot Patch needs rebase
2025-09-02 11:11:25 CFbot Patch does not need rebase anymore
2025-09-01 00:45:25 CFbot Patch needs rebase
2025-08-30 15:03:29 CFbot Patch does not need rebase anymore
2025-08-28 10:09:26 CFbot Patch needs rebase
2025-08-25 21:41:31 CFbot Patch does not need rebase anymore
2025-08-22 07:53:20 CFbot Patch needs rebase
2025-08-21 02:24:30 CFbot Patch does not need rebase anymore
2025-08-21 02:08:17 Peter Smith (smithpb2250) Moved from CF PG19-1 to CF PG19-Drafts
2025-07-31 08:38:23 CFbot Patch needs rebase
2025-07-30 00:34:30 CFbot Patch does not need rebase anymore
2025-07-22 08:50:24 CFbot Patch needs rebase
2025-07-19 16:41:29 CFbot Patch does not need rebase anymore
2025-07-18 00:51:33 CFbot Patch needs rebase
2025-07-11 09:35:32 CFbot Patch does not need rebase anymore
2025-07-09 09:14:22 CFbot Patch needs rebase
2025-07-05 18:01:31 CFbot Patch does not need rebase anymore
2025-06-28 13:49:36 CFbot Patch needs rebase
2025-06-26 18:30:52 CFbot Patch does not need rebase anymore
2025-06-19 05:42:47 CFbot Patch needs rebase
2025-06-19 05:40:03 Peter Smith (smithpb2250) Attached mail thread OS7PR01MB119648CA4E8502FE89056E56EEA7D2@OS7PR01MB11964.jpnprd01.prod.outlook.com
2025-06-19 05:40:03 Peter Smith (smithpb2250) Created patch record
Edit