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)