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