Options

Does executing ANALYZE_CONSTRAINTS on a table lock the table so that other transactions can't write?

Will analyze_constraints on a table lock out other transactions from writing that same table?
Will analyze_constraints on a table lock out other transactions from reading that same table?

From

https://my.vertica.com/docs/6.1.x/HTML/index.htm#11175.htm

We see that

'ANALYZE_CONSTRAINTS() performs a lock in the same way that SELECT * FROM t1 holds a lock on table t1. See LOCKS for additional information.'


But I'm not sure if analyze_constraints on a table locks out other sessions/transactions from reading or writing to that same table.

Assume that we are using the default read committed isolation level.  Also assume that we are only trying to read and insert.  No updates or deletes are being performed.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file