PostgreSQL Index Locking

Index locking

• https://www.postgresql.org/docs/current/index-locking.html

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)

Related

AccessShareLock

See also

• VACUUM: PostgreSQL VACUUM, Autovacuum, pg_database, pg_stat_activity, Redshift VACUUM
• Index (PostgreSQL): create index, Index Locking
• Locking, Index locking