Re: [WIP]Vertical Clustered Index (columnar store extension) - take2

Peter Smith <smithpb2250@gmail.com>

From: Peter Smith <smithpb2250@gmail.com>

To: Timur Magomedov <t.magomedov@postgrespro.ru>

Cc: Tomas Vondra <tomas@vondra.me>, "Aya Iwata (Fujitsu)" <iwata.aya@fujitsu.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>

Date: 2025-07-02T06:23:25Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Mark ItemPointer arguments as const throughout
- e1ac846f3d28 19 (unreleased) cited
Reorganize GUC structs
- a13833c35f9e 19 (unreleased) cited
Eliminate XLOG_HEAP2_VISIBLE from vacuum phase III
- add323da40a6 19 (unreleased) cited
Update various forward declarations to use typedef
- d4d1fc527bdb 19 (unreleased) cited
Pathify RHS unique-ification for semijoin planning
- 24225ad9aafc 19 (unreleased) cited
Revert "Don't lock partitions pruned by initial pruning"
- 1722d5eb05d8 18.0 cited
For inplace update, send nontransactional invalidations.
- 243e9b40f1b2 18.0 cited
Remove nearly-unused SizeOfIptrData macro.
- 8023b5827fba 10.0 cited

Attachments

v10-0003-VCI-module-documentation.patch (application/octet-stream) patch v10-0003
v10-0001-VCI-changes-to-postgres-core.patch (application/octet-stream) patch v10-0001
v10-0002-VCI-module-main.patch (application/octet-stream) patch v10-0002

Here are the latest v10* patches

The main differences are:

PATCH 0001 (core)
- Rebase was needed due to changes in master.
- Removed all embedded vci relopts (per Timur report [1] these were
not being used).

PATCH 0002 (vci module)
- Changed extension version 1.0 to instead of 2.0
- Fixed several cfbot reported meson problems + WIN32 syntax errors
- Removed some more dead/unreachable code since "vci_create()"
function is not implemented
- Updated README to remove the "max_index_keys" difference.

======
[1] https://www.postgresql.org/message-id/7327bade206c4973b43056a3fc2ad2e7b5dec919.camel%40postgrespro.ru

Kind Regards,
Peter Smith.
Fujitsu Australia