VCI (columnar store extension)

Edit
ID 5829
Title VCI (columnar store extension)
CI (CFBot) Summary
Stats (from CFBot) Patch version: v30, Patch count: 3, First patch: +664−100, All patches: +43160−101
Topic Server Features
Tags
Created 2025-06-19 05:40:03
Last modified 2025-09-25 09:00:09 (4 weeks ago)
Latest email 2025-10-14 05:44:25 (1 week ago)
Status
PG19-Drafts (2025-06-22 – 2026-02-28): Needs review
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 2025-10-14 05:44:25 by Peter Smith <smithpb2250 at gmail.com>
Latest attachment (v30-0001-VCI-changes-to-postgres-core.patch) at 2025-10-14 05:44:25 from Peter Smith <smithpb2250 at gmail.com>
    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
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