[WIP]Vertical Clustered Index (columnar store extension) - take2 #166
Description
--- As of 2026-02-10T18:19:28.000Z ---
Peter Smith submitted a rebased set of VCI patches for the Vertical Clustered Index columnar store extension. Álvaro Herrera responded with strong concerns about the current design direction, stating that the full-blown executor implementation in contrib/ using hooks in heapam and transaction machinery is unacceptable and won't be accepted. He advocates for reimplementing it as a new table AM in src/backend/access/ with proper executor support, acknowledging this would be a huge undertaking requiring significant employer buy-in. Despite the risks, Herrera emphasizes that a good columnar store is crucial for PostgreSQL. Alexandre Felipe supports the project and proposes a phased development approach with design principles focusing on pluggability, usefulness, simplicity, and limited scope. He outlines three phases: preparatory work with hooks, core implementation for scans with aggregations, and opportunistic ROS updates. The discussion centers on finding an acceptable architectural direction rather than continued minor rebasing.
Peter Smith提交了VCI补丁的重新基准版本，用于Vertical Clustered Index列存储扩展。Álvaro Herrera对当前设计方向表达了强烈担忧，声明在contrib/中使用heapam和事务机制钩子的完整执行器实现是不可接受的，不会被接受。他主张将其重新实现为src/backend/access/中的新表AM，配以适当的执行器支持，并承认这将是一项巨大的工程，需要雇主的重大支持。尽管存在风险，Herrera强调良好的列存储对PostgreSQL至关重要。Alexandre Felipe支持该项目，并提出了分阶段开发方法，设计原则专注于可插拔性、实用性、简单性和有限范围。他概述了三个阶段：使用钩子的准备工作、用于扫描和聚合的核心实现，以及机会性ROS更新。讨论的核心是寻找可接受的架构方向，而不是继续进行小幅度重新基准。
participants - 参与者: