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 |
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 |