Looking into details of locking
Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
July 23, 2019
(thanks @skeswani for query and advice) If you have a lot of concurrent queries, especially mixing DDL and DML, you might see lock contention. If you'd like to see how locks interact in your system, the following queries generate a temporary table with Gantt chart to show an ordered list of locks over time: Query (be...