Tag: #connection-pool
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 4 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#performanceBackend Performance Engineering Complete Guide 2025: Profiling, Load Testing, Bottleneck Analysis, Optimization
Everything about backend performance! Profiling (CPU/Memory/I-O), load testing (k6/Artillery/Locust), bottleneck analysis (DB/Network/CPU/Memory), N+1 resolution, connection pool tuning, caching strategies (Redis/CDN/App
2026-04-14 · 21 min read #backend-performance#profiling#load-testing#optimization#k6Database Performance Tuning Complete Guide: Query Optimization, Index Strategy, Connection Pool Management
Everything about DB performance tuning! EXPLAIN ANALYZE interpretation, index design (B-Tree/GIN/BRIN), slow query analysis, connection pooling (HikariCP/PgBouncer), N+1 resolution, partitioning, read replicas, query cac
2026-03-24 · 22 min read #database#performance#tuning#indexing#query-optimization