Skip to content

Glossary: PostgreSQL Beyond the Basics

Advisory locks

Also written: session-level advisory locks

Locks an app takes on a number of its own choosing, not on a table or row. Session-level ones break under PgBouncer's transaction mode.

Where the book teaches it

Related terms

PgBouncer, pool modes