4 ms·
Pretty common advice for scaling Postgres is to deploy pgbouncer in transaction mode in front of it to handle connection pooling. Advisory locks don’t work in
by mikeocool 3y ago
Pretty common advice for scaling Postgres is to deploy pgbouncer in transaction mode in front of it to handle connection pooling.
Advisory locks don’t work in this setup (and will start behaving in strange ways if you do try to use them.) Something to consider if you go this route.
- paulddraper 3y agoDepends. That has more to do with how your're scaling application servers.
- ris 3y agoTransaction-scoped advisory locks are very much a thing too.