PgBouncer: Database Connection Pooling That Actually Scales

<a href="https://news.ycombinator.com/item?id=48819308">Comments</a>

<p>If you have ever built an application that talks to a database, you have used a database connection. A database is simply a structured storage system for digital information,

<p><em>B-tree internals, column order and planner statistics in Postgres 19, checked against MongoDB's ESR rule.</em></p> <p>Most "add an index" advice stops at <code>CREATE

<blockquote> <p>The pager went off at 2:14 AM.</p> </blockquote> <p>If you’ve spent any time operating distributed systems, you know that sound. It doesn’t just wake you up; it

<a href="https://news.ycombinator.com/item?id=48872874">Comments</a>

<p>A good way to market a new infrastructure tool is to loudly announce that it is a thousand times faster than whatever you are currently using. This is a very effective strategy

<p>A team notices a checkout endpoint slowing down. Response times have crept from 80ms to 900ms over two weeks, but the infrastructure dashboard shows nothing abnormal. So the

<p>Cómo un backend de FastAPI + asyncpg comparte un solo Postgres chiquito con sus propios trabajadores en segundo plano y un segundo servicio, por qué el techo de conexiones, no