Skip to main content

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

  • February 28, 2014
  • 0 replies
  • 8 views

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