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

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Tomas Vondra <tomas(at)vondra(dot)me>
Cc: "Aya Iwata (Fujitsu)" <iwata(dot)aya(at)fujitsu(dot)com>, "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-26 05:07:25
Message-ID: CAHut+PvYUZWkkRTZJE622MmSaVrmnWOV63bmkmWo4AfjT827Wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Tomas.

Thankyou for your extremely valuable post [1]. We are analysing your
review comments and feedback, and will respond later.

Meanwhile, I am attaching updated patches to address the reported
build problems:

> I also tried to build 0002, but unfortunately that fails with:
>
> executor/vci_executor.c: In function ‘vci_setup_executor_hook’:
> executor/vci_executor.c:115:28: error: assignment to
> ‘ExecutorStart_hook_type’ {aka ‘void (*)(QueryDesc *, int)’} from
> incompatible pointer type ‘_Bool (*)(QueryDesc *, int)’
> [-Wincompatible-pointer-types]
> 115 | ExecutorStart_hook = vci_executor_start_routine;
> | ^
> executor/vci_executor.c: In function ‘vci_executor_start_routine’:
> executor/vci_executor.c:161:28: error: void value not ignored as it
> ought to be
> 161 | plan_valid = executor_start_prev(queryDesc, eflags);
> | ^
> executor/vci_executor.c:163:28: error: void value not ignored as it
> ought to be
> 163 | plan_valid = standard_ExecutorStart(queryDesc,
> eflags);
> | ^
> make: *** [../../src/Makefile.global:973: executor/vci_executor.o] Error 1
>
> The extension is not added to contrib/Makefile, so "make world" does not
> trigger this failure.

patch v3-0001.
- Only some whitespace issues are addressed

patch v3-0002.
- Fixed the contrib/Makefile to include vci
- Fixed a build error (due to recent commit [2])
- The vci.sgml file is removed (now in patch 0003)

patch v3-0003
- New patch just for the docs.

======
[1] https://www.postgresql.org/message-id/a748aa6b-c7e6-4d02-a590-ab404d590448%40vondra.me
[2] https://github.com/postgres/postgres/commit/1722d5eb05d8e5d2e064cd1798abcae4f296ca9d

Kind Regards,
Peter Smith.
Fujitsu Australia

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2025-05-26 05:57:19 Re: SQL:2011 application time
Previous Message Tom Lane 2025-05-26 03:54:01 Re: CREATE OR REPLACE FUNCTION now validates it's dependents