Vertica Blog

Vertica Blog

Locks

Lock

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...

What is a Lock Anyway?

Sarah Lemaire, Manager, Vertica Documentation
May 19, 2015

We talk a lot about database security and how you can protect your sensitive data from outside threats. But what about internal, unintentional data corruption? What if the data you are trying to analyze or manipulate is simultaneously being manipulated by another transaction? A scenario such as this could lead to data loss and inconsistency....