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

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Japin Li <japinli(at)hotmail(dot)com>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tomas Vondra <tomas(at)vondra(dot)me>, "Aya Iwata (Fujitsu)" <iwata(dot)aya(at)fujitsu(dot)com>, Timur Magomedov <t(dot)magomedov(at)postgrespro(dot)ru>, shveta malik <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: [WIP]Vertical Clustered Index (columnar store extension) - take2
Date: 2025-08-14 01:39:21
Message-ID: CAHut+PtmbGGkmHz3NcnqPBWuhRHkzWGe_8Sx=--DgwAyH_da3g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 12, 2025 at 1:48 PM Japin Li <japinli(at)hotmail(dot)com> wrote:
...
> 1.
> PFA the other typos.
>

Fixed in v18.

> 2.
> I found it skip vci query context initialization in vci_intialize_query_context()
> if full page writes is disabled, Could you explain why we need full page write
> enabled for VCI?
>

TODO

> 3.
> Both vci_ros.h and vci_ros.c have a comment about accessing the VCI main relation
> header, but they are slightly different. Could we sync them and keep only one?
>
> It seems the comment is outdated, as the functions vci_KeepReadingMainRelHeader()
> and vci_KeepWritingMainRelHeader() do not exist in the current VCI implementation.
>

TODO. I agree that there should be only one comment, and outdated
function references need to be fixed.

> 4.
> +/**
> + * This function is assumed when the VCI index is newly built, and
> + * it converts all the data in the relation of PostgreSQL into ROS.
> + */
> +uint64
> +vci_ConvertWos2RosForBuild(Relation mainRel,
> + Size workareaSize,
> + IndexInfo *indexInfo)
> ...
> + result = (uint64) table_index_build_scan(comContext.heapRel,
> + mainRel,
> + indexInfo,
> + true, /* allow syncscan */
> + true,
> + vci_build_callback,
> + (void *) &comContext, NULL)
>
> Perhaps we can use a double return type to avoid type casting since
> other places also use double.

Fixed in v18.

======
Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2025-08-14 01:44:56 Re: [WIP]Vertical Clustered Index (columnar store extension) - take2
Previous Message Peter Smith 2025-08-14 01:35:14 Re: [WIP]Vertical Clustered Index (columnar store extension) - take2