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)
