Tag: #pgbouncer
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 3 posts
The Complete Guide to Connection Pools: The Contract a Pooling Mode Makes with Your Application
A look at connection pools through the lens of a contract, based on PostgreSQL 18 and PgBouncer. Covers what the three pooling modes, session, transaction, and statement, each guarantee and each give up; why prepared sta
2026-08-15 · 16 min read #database#postgresql#pgbouncer#connection-pool#operationsWhy a Big Connection Pool Costs You — Deciding Where to Put the Queue
An explanation of the mechanism behind the phenomenon where enlarging a connection pool actually makes things slower. Why a connection is expensive under the process model of PostgreSQL, why it is better to put the queue
2026-07-26 · 15 min read #database#postgresql#connection-pool#pgbouncer#performanceModern PostgreSQL 2026 — Postgres 17 / 18 / pgvector / pgvectorscale / pgai / TimescaleDB / PostGIS / Citus Deep Dive
A snapshot of the PostgreSQL ecosystem as of May 2026. Covers Postgres 17 (Sept 2024) incremental backup, JSONTABLE, and MERGE improvements, Postgres 18 (Sept 2025) virtual generated columns and OAuth2, the vector extens
2026-05-16 · 24 min read #postgresql#postgres-17#postgres-18#pgvector#pgvectorscale