This article explains how disabling the EnableOptDeleteTempRel parameter in Vertica resolved performance issues with UPDATE and DELETE operations after upgrading from version 12.3.x to 24.4.x. The parameter is designed to optimize complex joins but may introduce overhead for simpler queries.
Environment
- Vertica Analytics Platform
- Upgrade path: 12.3.x → 24.4.x
- DML operations:
UPDATE,DELETE - Configuration parameter:
EnableOptDeleteTempRel
Situation
After upgrading Vertica, the customer observed that UPDATE and DELETE operations were slow or unresponsive. The issue was traced to the EnableOptDeleteTempRel parameter, which was enabled by default.
