Simple Vertica
Thursday, June 23, 2016
Find the default Isolation level in Vertica
By default, Vertica uses the READ COMMITTED isolation level.
=>SHOW transaction_isolation;
=> ALTER DATABASE mydb SET TransactionIsolationLevel = 'SERIALIZABLE';
=> ALTER DATABASE mydb SET TransactionIsolationLevel = 'READ COMMITTED';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment