Improving performance of data analysis with Vertical Clustered Index
Improving performance of data analysis with Vertical Clustered Index
8 PagesFujitsu’s Vertical Clustered Index (VCI) enhances PostgreSQL by enabling simultaneous OLTP and OLAP performance through in-memory columnar indexing. VCI stores data in both row- and column-oriented formats using Write Optimized Store (WOS) and Read Optimized Store (ROS), enabling real-time analytics without affecting transactions. Asynchronous updates and disk storage of columnar data ensure consistency, fast restarts, and efficient aggregation. VCI boosts query performance up to 5x while maintaining transactional throughput, supporting HTAP workloads and accelerating business intelligence without modifying existing applications.
