In PostgreSQL, We can apply different lock mode on the table. This is also one of the important topics because PostgreSQL has a default MVCC architecture. What is Multi Version Concurrency Control (MVCC) Because of MVCC architecture, all other sessions can access table new data or an old version of the data. Sometimes Isolation Level … Continue reading PostgreSQL: How to apply ACCESS EXCLUSIVE LOCK MODE on Table?