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

From: "Aya Iwata (Fujitsu)" <iwata(dot)aya(at)fujitsu(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: RE: [WIP]Vertical Clustered Index (columnar store extension) - take2
Date: 2025-05-09 10:08:26
Message-ID: OS7PR01MB119643D6301D6F9EDAF958BF9EA8AA@OS7PR01MB11964.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

We created VCI patch.
This patch is a prototype. The build and postgres regression tests have passed,
but there are still some bugs.

This patch includes the following VCI implementations:

- Changes to PostgreSQL core code
- Conversion of WOS to ROS
-- The source code for the conversion part exists. However, there is a slight
source code problem. To avoid this problem,
the vci.enable_ros_control_damon parameter now defaults to false. This change
prevents the ROS control daemon from starting at instance startup.
Background workers that convert WOS to ROS are not created because there is
no ROS control daemon.
- Convert to Local ROS
- Custom Plan VCI Scan
- Data transformation by background workers
- Minimum test
- Minimum documentation

This patch provides the following steps to use VCI:

1. Create Table
2. Insert data into the table
3. Create VCI
4. Run VCI Scan

The functions we will be developing are described in the wiki,
so please refer to it.
https://wiki.postgresql.org/wiki/Vertical_clustered_index

Regards,
Aya Iwata
Fujitsu Limited

Attachment Content-Type Size
0001-Add-postgres-code-fix-needed-for-VCI.patch application/octet-stream 118.4 KB
0002-Add-VCI-module.patch application/octet-stream 1.3 MB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stepan Neretin 2025-05-09 10:24:46 Re: [PATCH] avoid double scanning in function byteain
Previous Message Alvaro Herrera 2025-05-09 09:44:24 Re: Assert failure in base_yyparse