Closing a session in Vertica, even with local temporary tables that don’t require rollback, involves resource cleanup, transaction management, and dependency checks, which can introduce delays. To optimize closure time, explicitly dropping temporary tables before closing the session can help free up memory faster.
Products: Vertica Analytics Platform
Environment
All Vertica version.
Situation
Why Does Closing the Session Take Time for a Local Temp Table?
