select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

pg_lock_pool

Wait on a PostgreSQL advisory lock pool

pgext.cloud · Source code · Documentation · Control file · PGXN

Overview

Packagepg_lock_pool
Version0.0.1
PostgreSQL versions12 · 13 · 14 · 15 · 16 · 17
RepositoryUnspecified
Extension typeSQL only
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars2
Latest commit2025-06-26
Latest release2023-12-06
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pgquePure SQL PostgreSQL job queue that orders jobs by priority and claims them with advisory locks.
pglockLightweight distributed lock service inside PostgreSQL
pg_xclaimHigh-cardinality transaction-scoped logical claim primitive for PostgreSQL
short_idsPL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks.
tuplocklock tuples (rows) with a boolean attribute
pg_repackReorganize tables in PostgreSQL databases with minimal locks
shardmanExperimental sharding, rebalance, and cross-node lock-graph prototype
debug_funcsDebugging and benchmark functions for PostgreSQL buffer and relation locks.