| Lock | Kommandos | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
|---|---|---|---|---|---|---|---|---|---|
| 1 ACCESS SHARE | SELECT | x | |||||||
| 2 ROW SHARE | SELECT FOR UPDATE, SELECT FOR SHARE | x | x | ||||||
| 3 ROW EXCLUSIVE | UPDATE, DELETE, INSERT | x | x | x | x | ||||
| 4 SHARE UPDATE EXCLUSIVE | VACUUM (ohne FULL), ANALYZE, CREATE INDEX CONCURRENTLY | x | x | x | x | x | |||
| 5 SHARE | CREATE INDEX (ohne CONCURRENTLY | x | x | x | x | x | x | ||
| 6 SHARE ROW EXCLUSIVE | wird von keinem Kommando gesetzt | x | x | x | x | x | x | ||
| 7 EXCLUSIVE | wird von keinem Kommando gesetzt aber von den Systemkatalogen | x | x | x | x | x | x | x | |
| 8 ACCESS EXCLUSIVE | ALTER TABLE, DROP TABLE, TRUNCATE, REINDEX, CLUSTER, VACUUM FULL | x | x | x | x | x | x | x | x |
ZURÜCK Weiter zu: PostgreSQL.de pgsql.info