Fujitsu’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.

Join for free to read