↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 锁

SHARE UPDATE EXCLUSIVE

Conflicts with the SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. This mode protects a table against concurrent schema changes and VACUUM runs. Acquired by VACUUM (without FULL), ANALYZE, CREATE INDEX CONCURRENTLY, CREATE STATISTICS, COMMENT ON, REINDEX CONCURRENTLY, and certain ALTER INDEX and ALTER TABLE variants (for full details see the documentation of these commands).

当前阅读 PG 18·选择有来源记录的版本

1011121314151617181920

此版本暂无所选语言的定义，以下显示原始英文内容。

兼容性

比较不同事务持有同一对象的锁 表锁.

× 冲突模式

· 兼容模式

查看完整兼容性矩阵

取得此锁模式的命令

SQL 命令对象、阶段与条件
VACUUM (without FULL)Ordinary vacuum holds this mode; truncating empty tail pages can briefly require ACCESS EXCLUSIVE. 来源
ANALYZELock the table being analyzed. 来源
CREATE INDEX CONCURRENTLYLock the indexed table. Building proceeds across transactions and waits for old transactions where necessary. 来源
CREATE STATISTICSLock the table whose extended statistics are being defined. 来源
COMMENT ON (relation object)Lock the object being commented on. Identical modes on different objects do not conflict. 来源
DROP INDEX CONCURRENTLYLock the parent table while removing the index across phases; unlike ordinary DROP INDEX this does not hold ACCESS EXCLUSIVE on the table. 来源
REINDEX … CONCURRENTLYFrom PostgreSQL 12, session-level SHARE UPDATE EXCLUSIVE locks cover the rebuilt index and its table through the build, validation, swap and cleanup transactions. 来源
LOCK TABLE … IN SHARE UPDATE EXCLUSIVE MODERequest this table mode explicitly. Omitting IN MODE defaults to ACCESS EXCLUSIVE. 来源
ALTER TABLE … ALTER COLUMN … SET STATISTICSChange the column statistics target. 来源
ALTER TABLE … ALTER COLUMN … SET (n_distinct = …)Change column statistics options; RESET has the same requirement. 来源
ALTER TABLE … CLUSTER ONChoose the index for future clustering; this command does not rewrite the table. 来源
ALTER TABLE … SET WITHOUT CLUSTERClear the clustering-index designation. 来源
ALTER TABLE … VALIDATE CONSTRAINTValidate a constraint on this table. Foreign-key validation also accesses the referenced table. 来源
ALTER TABLE … ATTACH PARTITION (parent table)The parent lock is extracted separately for every version. The table being attached additionally requires ACCESS EXCLUSIVE. From PostgreSQL 11 a default partition, if any, is also locked. 来源
ALTER TABLE … DETACH PARTITION … FINALIZE (parent table)Complete an interrupted concurrent detach. The detached partition additionally requires ACCESS EXCLUSIVE. 来源
ALTER TABLE … SET / RESET (fillfactor = …)Each storage parameter specifies its required mode. fillfactor can use SHARE UPDATE EXCLUSIVE. 来源
ALTER TABLE … SET / RESET (autovacuum_* = …)Table autovacuum storage options use SHARE UPDATE EXCLUSIVE. 来源
ALTER TABLE … SET / RESET (toast.autovacuum_* = …)These are TOAST autovacuum options. There is no generic SET TOAST subcommand; other options follow their own lock requirements. 来源
ALTER TABLE … DETACH PARTITION … CONCURRENTLY (parent table)From PostgreSQL 14, concurrent detach uses two transactions. The parent holds SHARE UPDATE EXCLUSIVE and waits for transactions using the partition before finalizing. 来源
ALTER TABLE … DETACH PARTITION … CONCURRENTLY (partition, first phase)In the first phase, parent and partition hold SHARE UPDATE EXCLUSIVE. The partition lock is upgraded after committing and waiting. 来源
ALTER INDEX … RENAMELock the index being renamed. 来源
ALTER TABLE … INHERIT (parent table)Take SHARE UPDATE EXCLUSIVE on the newly designated parent. The altered child separately takes ACCESS EXCLUSIVE. 来源

其他锁模式

conflicts
share-update-exclusive, share, share-row-exclusive, exclusive, access-exclusive
summary
Conflicts with the SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. This mode protects a table against concurrent schema changes and VACUUM runs.

版本定义 PG 18

Conflicts with the SHARE UPDATE EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and ACCESS EXCLUSIVE lock modes. This mode protects a table against concurrent schema changes and VACUUM runs. Acquired by VACUUM (without FULL), ANALYZE, CREATE INDEX CONCURRENTLY, CREATE STATISTICS, COMMENT ON, REINDEX CONCURRENTLY, and certain ALTER INDEX and ALTER TABLE variants (for full details see the documentation of these commands).

比较版本

完整来源事实

commands

map[label:VACUUM (without FULL) note:Ordinary vacuum holds this mode; truncating empty tail pages can briefly require ACCESS EXCLUSIVE. slug:vacuum source:map[kind:command-documentation path:doc/src/sgml/ref/vacuum.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:80ca5592cda7b74938385f84f09faac33574374c1a05d605a2d55982e4cf1bbf url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/vacuum.sgml] source_url:https://www.postgresql.org/docs/18/sql-vacuum.html variant:9ac837fe9402], map[label:ANALYZE note:Lock the table being analyzed. slug:analyze source:map[kind:documentation path:doc/src/sgml/mvcc.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:4b7bf77ee0af4b86052330ff2421d567df3604b75fe7d4f522bec84fdea87340 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/mvcc.sgml] source_url:https://www.postgresql.org/docs/18/explicit-locking.html variant:85d9dda4a06a], map[label:CREATE INDEX CONCURRENTLY note:Lock the indexed table. Building proceeds across transactions and waits for old transactions where necessary. slug:create-index source:map[kind:command-documentation path:doc/src/sgml/ref/create_index.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:3698f11c6f447d127e4624a1a845dee4d5146b8337ddc6d895a7962e676717f8 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/create_index.sgml] source_url:https://www.postgresql.org/docs/18/sql-createindex.html variant:89650aa6cbd4], map[label:CREATE STATISTICS note:Lock the table whose extended statistics are being defined. slug:create-statistics source:map[kind:documentation path:doc/src/sgml/mvcc.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:4b7bf77ee0af4b86052330ff2421d567df3604b75fe7d4f522bec84fdea87340 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/mvcc.sgml] source_url:https://www.postgresql.org/docs/18/explicit-locking.html variant:3eab135d4bfb], map[label:COMMENT ON (relation object) note:Lock the object being commented on. Identical modes on different objects do not conflict. slug:comment source:map[kind:command-documentation path:doc/src/sgml/ref/comment.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:d0048329d237192696d7ccb9471aba4137d943556fdb770e2ffb3cf6c511c18f url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/comment.sgml] source_url:https://www.postgresql.org/docs/18/sql-comment.html variant:aa34ba3000fe], map[label:DROP INDEX CONCURRENTLY note:Lock the parent table while removing the index across phases; unlike ordinary DROP INDEX this does not hold ACCESS EXCLUSIVE on the table. slug:drop-index source:map[kind:source path:src/backend/catalog/index.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:98a4156a5c21ae856a3b583b633cdeb578a5b69910386c9f166d69fcb04ba2d0 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/catalog/index.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/catalog/index.c variant:9d77a55b9d0a], map[label:REINDEX … CONCURRENTLY note:From PostgreSQL 12, session-level SHARE UPDATE EXCLUSIVE locks cover the rebuilt index and its table through the build, validation, swap and cleanup transactions. slug:reindex source:map[kind:command-documentation path:doc/src/sgml/ref/reindex.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:5e889d6e1d9b09d5f9cd3f7086ca13f540da0fe8262cdd8a9037ce9aa6f1dfdf url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/reindex.sgml] source_url:https://www.postgresql.org/docs/18/sql-reindex.html variant:ccb665fd4b59], map[label:LOCK TABLE … IN SHARE UPDATE EXCLUSIVE MODE note:Request this table mode explicitly. Omitting IN MODE defaults to ACCESS EXCLUSIVE. slug:lock source:map[kind:documentation path:doc/src/sgml/mvcc.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:4b7bf77ee0af4b86052330ff2421d567df3604b75fe7d4f522bec84fdea87340 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/mvcc.sgml] source_url:https://www.postgresql.org/docs/18/explicit-locking.html variant:865df2acefde], map[label:ALTER TABLE … ALTER COLUMN … SET STATISTICS note:Change the column statistics target. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:2cd99707d4fc], map[label:ALTER TABLE … ALTER COLUMN … SET (n_distinct = …) note:Change column statistics options; RESET has the same requirement. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:e273e1054328], map[label:ALTER TABLE … CLUSTER ON note:Choose the index for future clustering; this command does not rewrite the table. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:8f7dd3b2e2b2], map[label:ALTER TABLE … SET WITHOUT CLUSTER note:Clear the clustering-index designation. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:1b73447ed84d], map[label:ALTER TABLE … VALIDATE CONSTRAINT note:Validate a constraint on this table. Foreign-key validation also accesses the referenced table. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:c5e16a929f91], map[label:ALTER TABLE … ATTACH PARTITION (parent table) note:The parent lock is extracted separately for every version. The table being attached additionally requires ACCESS EXCLUSIVE. From PostgreSQL 11 a default partition, if any, is also locked. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:49874ab8f534], map[label:ALTER TABLE … DETACH PARTITION … FINALIZE (parent table) note:Complete an interrupted concurrent detach. The detached partition additionally requires ACCESS EXCLUSIVE. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:8b7eedbf4be5], map[label:ALTER TABLE … SET / RESET (fillfactor = …) note:Each storage parameter specifies its required mode. fillfactor can use SHARE UPDATE EXCLUSIVE. slug:alter-table source:map[kind:command-documentation path:doc/src/sgml/ref/alter_table.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:10436673fa2f093bdf51986a06d22dd748a9bb003bcd5517db2a65fba569a3c9 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_table.sgml] source_url:https://www.postgresql.org/docs/18/sql-altertable.html variant:3c5d906c57ed], map[label:ALTER TABLE … SET / RESET (autovacuum_* = …) note:Table autovacuum storage options use SHARE UPDATE EXCLUSIVE. slug:alter-table source:map[kind:command-documentation path:doc/src/sgml/ref/alter_table.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:10436673fa2f093bdf51986a06d22dd748a9bb003bcd5517db2a65fba569a3c9 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_table.sgml] source_url:https://www.postgresql.org/docs/18/sql-altertable.html variant:45ad34a0df95], map[label:ALTER TABLE … SET / RESET (toast.autovacuum_* = …) note:These are TOAST autovacuum options. There is no generic SET TOAST subcommand; other options follow their own lock requirements. slug:alter-table source:map[kind:command-documentation path:doc/src/sgml/ref/alter_table.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:10436673fa2f093bdf51986a06d22dd748a9bb003bcd5517db2a65fba569a3c9 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_table.sgml] source_url:https://www.postgresql.org/docs/18/sql-altertable.html variant:0c41e035a785], map[label:ALTER TABLE … DETACH PARTITION … CONCURRENTLY (parent table) note:From PostgreSQL 14, concurrent detach uses two transactions. The parent holds SHARE UPDATE EXCLUSIVE and waits for transactions using the partition before finalizing. slug:alter-table source:map[kind:command-documentation path:doc/src/sgml/ref/alter_table.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:10436673fa2f093bdf51986a06d22dd748a9bb003bcd5517db2a65fba569a3c9 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_table.sgml] source_url:https://www.postgresql.org/docs/18/sql-altertable.html variant:ac6541a82960], map[label:ALTER TABLE … DETACH PARTITION … CONCURRENTLY (partition, first phase) note:In the first phase, parent and partition hold SHARE UPDATE EXCLUSIVE. The partition lock is upgraded after committing and waiting. slug:alter-table source:map[kind:command-documentation path:doc/src/sgml/ref/alter_table.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:10436673fa2f093bdf51986a06d22dd748a9bb003bcd5517db2a65fba569a3c9 url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_table.sgml] source_url:https://www.postgresql.org/docs/18/sql-altertable.html variant:f9fe4165672e], map[label:ALTER INDEX … RENAME note:Lock the index being renamed. slug:alter-index source:map[kind:command-documentation path:doc/src/sgml/ref/alter_index.sgml revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:746cd43287186dfbfa6acf77fd5c6713e66919653fb00af5476a0baa65988e7a url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_index.sgml] source_url:https://www.postgresql.org/docs/18/sql-alterindex.html variant:21b5336d267d], map[label:ALTER TABLE … INHERIT (parent table) note:Take SHARE UPDATE EXCLUSIVE on the newly designated parent. The altered child separately takes ACCESS EXCLUSIVE. slug:alter-table source:map[kind:source path:src/backend/commands/tablecmds.c revision:753057e340da8f22e57c9a409ea7a235fd6a46bd sha256:df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da url:https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c] source_url:https://github.com/postgres/postgres/blob/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c variant:423de0ea5acd]

provenance

{"doc_slug":"18","fetched_at":"2026-09-27T09:39:42+00:00","label":"18","major":"18","official_url":"https://www.postgresql.org/docs/18/explicit-locking.html","ref":"REL_18_STABLE","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sources":[{"kind":"command-documentation","path":"doc/src/sgml/ref/alter_index.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"746cd43287186dfbfa6acf77fd5c6713e66919653fb00af5476a0baa65988e7a","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_index.sgml"},{"kind":"command-documentation","path":"doc/src/sgml/ref/alter_table.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"10436673fa2f093bdf51986a06d22dd748a9bb003bcd5517db2a65fba569a3c9","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/alter_table.sgml"},{"kind":"command-documentation","path":"doc/src/sgml/ref/comment.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"d0048329d237192696d7ccb9471aba4137d943556fdb770e2ffb3cf6c511c18f","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/comment.sgml"},{"kind":"source","path":"src/backend/commands/copy.c","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"f50ecc1531109fc172d841d461e209cef611f3d017ef4184034c39e128deabbe","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/copy.c"},{"kind":"command-documentation","path":"doc/src/sgml/ref/create_index.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"3698f11c6f447d127e4624a1a845dee4d5146b8337ddc6d895a7962e676717f8","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/create_index.sgml"},{"kind":"source","path":"src/backend/access/heap/heapam.c","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"bca2ca0746a1862016bdb416b8482441a7b16360f71afe5e4abf6dbae0fa0c72","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/access/heap/heapam.c"},{"kind":"source","path":"src/backend/catalog/index.c","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"98a4156a5c21ae856a3b583b633cdeb578a5b69910386c9f166d69fcb04ba2d0","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/catalog/index.c"},{"kind":"command-documentation","path":"doc/src/sgml/ref/insert.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"f93403779fb1d980cd5995a1e2741bbdae8404584407610f9aba33ec4724a39f","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/insert.sgml"},{"kind":"source","path":"src/backend/storage/lmgr/lock.c","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"e7f43560bf6a8417ff46991238084b6edeb44a995b87670ed1f7fa6f1515276b","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/storage/lmgr/lock.c"},{"kind":"documentation","path":"doc/src/sgml/mvcc.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"4b7bf77ee0af4b86052330ff2421d567df3604b75fe7d4f522bec84fdea87340","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/mvcc.sgml"},{"kind":"command-documentation","path":"doc/src/sgml/ref/reindex.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"5e889d6e1d9b09d5f9cd3f7086ca13f540da0fe8262cdd8a9037ce9aa6f1dfdf","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/reindex.sgml"},{"kind":"source","path":"src/backend/utils/adt/ri_triggers.c","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"a3fed49fbda88fe0fe5bcf35eb019fced28596ae4046233f2acb2eb9f90ab1da","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/utils/adt/ri_triggers.c"},{"kind":"source","path":"src/backend/commands/tablecmds.c","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"df8817816f893e73d5648fea169e222ba33320e5b24bf755b424b29098f4e7da","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/commands/tablecmds.c"},{"kind":"command-documentation","path":"doc/src/sgml/ref/vacuum.sgml","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"80ca5592cda7b74938385f84f09faac33574374c1a05d605a2d55982e4cf1bbf","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/doc/src/sgml/ref/vacuum.sgml"},{"kind":"source","path":"src/backend/access/heap/vacuumlazy.c","revision":"753057e340da8f22e57c9a409ea7a235fd6a46bd","sha256":"90932e3b1a7b57dda8f740807def59aedb57fbd0e2173e3af3309f145192c7c2","url":"https://raw.githubusercontent.com/postgres/postgres/753057e340da8f22e57c9a409ea7a235fd6a46bd/src/backend/access/heap/vacuumlazy.c"}],"status":"stable"}

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · 10:f4e8f137bfb08a664c8288824c1e36b5143ac875;11:170e416034ec0231d9e9238f2577eeb76ca8d181;12:3f302f0ed06f69c5ebd33d4df95895323a3cbef6;13:05f6c9ec2c475fae8fdd56ae40bd01afcf70d1f2;14:fba35c7c28a567839faba867db0808564c0a66db;15:0351991b8e7c7b64382e2f30ce581a8f276590a6;16:dcc37b7099a9f3cf2c75167d8dc92e75f96bc1fa;17:163288afd32a448244c8df75b3c33181aadd7f20;18:753057e340da8f22e57c9a409ea7a235fd6a46bd;19:b73d13c32c834a2c8e1c60cb92f79530376cedf1;20:2c10c2ce4d7bcd57543a49ab402af02a39724e0a

正文语言: en · 10:f4e8f137bfb08a664c8288824c1e36b5143ac875;11:170e416034ec0231d9e9238f2577eeb76ca8d181;12:3f302f0ed06f69c5ebd33d4df95895323a3cbef6;13:05f6c9ec2c475fae8fdd56ae40bd01afcf70d1f2;14:fba35c7c28a567839faba867db0808564c0a66db;15:0351991b8e7c7b64382e2f30ce581a8f276590a6;16:dcc37b7099a9f3cf2c75167d8dc92e75f96bc1fa;17:163288afd32a448244c8df75b3c33181aadd7f20;18:753057e340da8f22e57c9a409ea7a235fd6a46bd;19:b73d13c32c834a2c8e1c60cb92f79530376cedf1;20:2c10c2ce4d7bcd57543a49ab402af02a39724e0a