PostgreSQLのテーブルレベルロックモード①
56
ロックモード 獲得タイミング
ACCESS SHARE SELECT
ROW SHARE SELECT FOR UPDATE, SELECT FOR SHARE
ROW EXCLUSIVE UPDATE, DELETE, INSERT
SHARE UPDATE EXCLUSIVE VACUUM, ANALYZE, CREATE INDEX CONCURRENTLY,
CREATE STATISTICS, ALTER TABLE VALIDATE及び他の
ALTER TABLEの亜種
SHARE CREATE INDEX
SHARE ROW EXCLUSIVE CREATE COLLATION, CREATE TRIGGER, ALTER TABLE
EXCLUSIVE REFRESH MATERIALIZED VIEW CONCURRENTLY
ACCESS EXCLUSIVE DROP TABLE, TRUNCATE, REINDEX, CLUSTER, VACUUM
FULL, REFRESH MATERIALIZED VIEW, ALTER TABLE,
LOCK TABLE
弱
強