PostgreSQL 12 lock

1. access share : select시

2. row exclusive : select for update / select for share 시

3. share update exclusive : create index concurrently, analyze, alter table, validate, vacuum 시

4. share row exclusive : create trigger, alter table 시

5. exclusive or access exclusive : table lock처럼 reading/writing 불가

   lock table test_table in access exclusive mode;

 

lock 무한정 기다리지 않게 lock_timeout를 지정 (5000 --> 5초)