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';