Difference between revisions of "AccessShareLock"
Jump to navigation
Jump to search
Line 4: | Line 4: | ||
+ | [[PostgreSQL Index Locking]] | ||
− | * {{ | + | * {{Locking}} |
Revision as of 10:29, 11 July 2023
Index access methods must handle concurrent updates of the index by multiple processes. The core PostgreSQL system obtains AccessShareLock on the index during an index scan, and RowExclusiveLock when updating the index (including plain VACUUM)
Advertising: