corpus.blog
56,966 blogs · 4,417,066 posts Claim your blog
Record · corpus.blog/posts/01a08791-acc9-7186-8dea-3eb3e43f6037

PgBouncer is useful, important, and fraught with peril

jpcamara.com · published 13 April 2023

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at jpcamara.com Wayback capture
2blogs citing
First cited
15 Oct 2023
Most recent
14 Jan 2026
Rank this month
not ranked
Links from this post
53
Words captured
8,585

Cited by

Blog
In the post
Date
Buttondown Newsletters
How we migrated our database to PlanetScale Read at the source ↗
14 Jan 2026
venki.com
When should you add Redis to Postgres? Read at the source ↗
15 Oct 2023

Links from this post

Link
Host
https://www.crunchydata.com
crunchydata.com
https://render.com/docs/databases
render.com
https://fly.io/docs/postgres/
fly.io
https://postgresml.org
postgresml.org
https://www.citusdata.com
citusdata.com
https://www.timescale.com
timescale.com
https://neon.tech
neon.tech
https://supabase.com
supabase.com
PgBouncer is now available in Supabase Read at the source ↗
supabase.com
https://elements.heroku.com/addons/heroku-postgresql
elements.heroku.com
https://www.enterprisedb.com/postgres-tutorials/why-you-should-use-connection-pooling-when-setting-maxconnections-postgres
enterprisedb.com
How to Manage Connections Efficiently in Postgres, or Any Database Read at the source ↗
brandur.org
https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/improving-postgres-connection-scalability-snapshots/ba-p/1806462
techcommunity.microsoft.com
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html
docs.aws.amazon.com
https://www.postgresql.org/docs/current/ddl.html
postgresql.org
https://medium.com/paypal-tech/postgresql-at-scale-database-schema-changes-without-downtime-20d3749ed680
medium.com
https://en.m.wikipedia.org/wiki/The_road_to_hell_is_paved_with_good_intentions
en.m.wikipedia.org
https://dba.stackexchange.com/a/81424/256107
dba.stackexchange.com
https://github.com/pgbouncer/pgbouncer/issues/249
github.com
https://www.crunchydata.com/blog/prepared-statements-in-transaction-mode-for-pgbouncer
crunchydata.com
https://www.pgbouncer.org/features.html
pgbouncer.org
https://cheatsheetseries.owasp.org/cheatsheets/SQL_Injection_Prevention_Cheat_Sheet.html
cheatsheetseries.owasp.org
https://guides.rubyonrails.org/configuring.html
guides.rubyonrails.org
https://github.com/pgbouncer/pgbouncer/pull/757
github.com
https://www.crunchydata.com/blog/logging-tips-for-postgres-featuring-your-slow-queries
crunchydata.com
https://www.postgresql.org/docs/current/libpq-single-row-mode.html
postgresql.org
https://rclayton.silvrback.com/distributed-locking-with-postgres-advisory-locks
rclayton.silvrback.com
https://jeremydmiller.com/2020/05/05/using-postgresql-advisory-locks-for-leader-election/
jeremydmiller.com
https://github.com/bensheldon/good_job
github.com
https://github.com/que-rb/que
github.com
https://www.postgresql.org/docs/current/sql-listen.html
postgresql.org
https://www.postgresql.org/docs/current/sql-notify.html
postgresql.org
https://news.ycombinator.com/item?id=17187436
news.ycombinator.com
https://www.crunchydata.com/blog/postgres-at-scale-running-multiple-pgbouncers
crunchydata.com
https://github.com/braintree/pg_ha_migrations
github.com
https://github.com/doctolib/safe-pg-migrations
github.com
https://github.com/ankane/strong_migrations
github.com
https://rubygems.org/gems/pg_pool_safe_query
rubygems.org
https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/analyzing-the-limits-of-connection-scalability-in-postgres/ba-p/1757266
techcommunity.microsoft.com
https://github.com/supabase/supavisor
github.com
https://github.com/postgresml/pgcat
github.com
https://github.com/yandex/odyssey
github.com
https://pgpool.net/mediawiki/index.php/Main_Page
pgpool.net
https://aws.amazon.com/rds/proxy/
aws.amazon.com
https://github.com/psycopg/psycopg
github.com
https://github.com/brianc/node-libpq
github.com
https://github.com/lib/pq/issues/889
github.com
https://github.com/launchbadge/sqlx/issues/368
github.com
https://github.com/pgbouncer/pgbouncer/issues/452
github.com
https://www.crunchydata.com/blog/is-your-postgres-ready-for-production
crunchydata.com
https://www.percona.com/blog/connection-queuing-in-pgbouncer-is-it-a-magical-remedy/
percona.com
https://github.com/pgbouncer/pgbouncer/issues/653
github.com
https://postgres.ai/blog/20210923-zero-downtime-postgres-schema-migrations-lock-timeout-and-retries
postgres.ai