Performance Improvements

Query Plans Support Late Materialization when Nodes are Down

When one or more nodes went down in earlier versions of Vertica, the Optimizer generated query plans that took the missing nodes into account. Specifically, the Optimizer creating a modified query plan for joins that used early materialization, which required more complex planning and executed less efficiently than the equivalent all-nodes-up plan.

Now when nodes are down, the Optimizer can generate plans that support late materialization. Plan creation is much simpler and incur less overhead. Execution time of nodes-down query plans is significantly better, equivalent now to all-nodes-up query plans.