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-06-12T07:06:19Z

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

v6-0001-VCI-changes-to-postgres-core.patch (application/octet-stream) patch v6-0001
v6-0005-VCI-module-documentation.patch (application/octet-stream) patch v6-0005
v6-0003-VCI-module-VCI_ENABLE_HOT_HASH_TABLE-code.patch (application/octet-stream) patch v6-0003
v6-0004-VCI-module-ENABLE_WOSROS_TRANS_DEFERRAL-co.patch (application/octet-stream) patch v6-0004
v6-0002-VCI-module-main.patch (application/octet-stream) patch v6-0002

Here are the v6 patches. The changes are as follows:

0001 (postgres core)
- now this addresses the rollback of "additional" optimization change
on master -- see report by Timur [1].
- minor cleanups

0002 (VCI module)
- updated with calls to TupleHashEntryGetAdditional() to support the 0001 fix
- build warnings fixed
- includes the contrib/vci/README
- minor meson changes

0003 (VCI_ENABLE_HOT_HASH_TABLE)
- minor meson changes

0004 (ENABLE_WOSROS_TRANS_DEFERRAL)
- rebased

0005 (docs)
- (unchanged)

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

Kind Regards,
Peter Smith.
Fujitsu Australia