07.10.2024 17:53, Aya Iwata (Fujitsu) wrote:
Hi All,
Suggestions
==========
When analyzing real-time data collected by PostgreSQL,
it can be difficult to tune the current PostgreSQL server for
satisfactory performance.
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.
I just don't get, why it should be "in-memory"? All the same things you
describe further, but storing in paged index on-disk with caching
through shared_buffers - why this way it wouldn't work?
