Skip to content

Glossary: PostgreSQL Beyond the Basics

SET LOCAL

Changes a setting only until the end of the current transaction, unlike a plain `SET`, which lasts for the session. It is safe with PgBouncer's transaction mode.

Where the book teaches it

Related terms

work_memPgBouncer, pool modes