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

Hello,

I came across this email by chance while looking for something else.

On 2024-Oct-07, Aya Iwata (Fujitsu) wrote:

> Therefore, we propose Vertical Clustered Indexing (VCI), an in-memory
> column store function that holds data in a state suitable for business
> analysis and is also expected to improve analysis performance.

> With VCI, you can also expect to run analysis 7.8 times faster. This
> is achieved by the analytics engine, which optimizes parallel
> processing of column-oriented data, in addition to the fact that VCI
> stores data in a columnar format, enabling efficient retrieval of the
> columns needed for analysis.

Wow.

> Request matter
> ===========
>
> Are members of the PostgreSQL hackers interested in VCI features?
> We welcome your comments and suggestions on this feature.
> In particular, if you have any questions, required features, or implementations, please let me know.

I think this is definitely an important and welcome development.
I look forward to your patches in this area.

Thank you,

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
Essentially, you're proposing Kevlar shoes as a solution for the problem
that you want to walk around carrying a loaded gun aimed at your foot.
(Tom Lane)