Simple Vertica
Showing posts with label
Default Isolation Level in Vertica
.
Show all posts
Showing posts with label
Default Isolation Level in Vertica
.
Show all posts
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';
Older Posts
Home
Subscribe to:
Posts (Atom)