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