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

From: "Aya Iwata (Fujitsu)" <iwata(dot)aya(at)fujitsu(dot)com>
To: 'Alexandre Felipe' <o(dot)alexandre(dot)felipe(at)gmail(dot)com>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Timur Magomedov <t(dot)magomedov(at)postgrespro(dot)ru>, Tomas Vondra <tomas(at)vondra(dot)me>, Japin Li <japinli(at)hotmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
Subject: RE: [WIP]Vertical Clustered Index (columnar store extension) - take2
Date: 2026-02-12 10:57:23
Message-ID: TYWPR01MB890148F5209E8E6AFD6A8D08EA60A@TYWPR01MB8901.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Alexandre-san

Thank you for summarizing the strategy. I agreed your design principle.
Per your phase, I feel we are on the phase 0 or 1, we can first commit the basic architecture.

> Note:
> I had different expectations, the first query uses two columns and filters over a 1-year period, the second query uses only one column and filters over.
> My first expectation was that if only one column is used there is less data being accessed.
> In my experience most queries will care about a timestamp column, it would be nice to be able to cluster the data by certain columns (in my case the created) column
> Maybe even clustering by multiple columns independently mediated by CRID permutations. If you think that this is easy enough we could insert this before phase 3.

The number of rows accessed by the first query and the number of
rows in the second query differ significantly.
This isn't only because one query uses a single column. Therefore,
I understood the advice to be that even when using VCI, it would be
beneficial to enable clustering on another column,
such as the created column, right?

Best regards,
Aya Iwata

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dean Rasheed 2026-02-12 11:11:25 Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values
Previous Message Anthonin Bonnefoy 2026-02-12 10:56:49 Re: LLVM 22