Pelin
Which PgBouncer pooling mode should I pick — Session, Transaction, or Statement?
Pick Transaction mode for a web fleet; the price is protocol-level prepared statements, so disable them in the app or turn on PgBouncer 1.21+ support.
All questions
Tag
#Performance
Latency, throughput and resource use: performance work that starts with a measurement. Questions under this tag, answered directly. (Page 2/2)
16 answered questions carry this tag.
Ozan
How do I do graceful shutdown on SIGTERM during autoscaling scale-in?
On SIGTERM drain the load balancer first, finish in-flight work inside the server.Shutdown(ctx) deadline, then align the grace period with that drain.
Doğa
How do I choose the right composite index column order in PostgreSQL?
Build one (user_id, status, created_at DESC) index with equality columns first and the sort column last, then drop the single-column indexes it now covers.
Cem
How do I prevent a Redis cache stampede (thundering herd) — mutex lock or XFetch?
A single-flight lock plus TTL jitter covers most cases; reach for XFetch only when recompute is truly expensive, and add stale-while-revalidate either way.
Arda
How do I cut GC pressure in Go with sync.Pool and escape analysis under load?
The enemy behind the pauses is allocation rate: kill the top allocator with pprof, pool the hot path with sync.Pool, and tune GOGC last, not first.
Yiğit
How do I debug memory leaks under Laravel Octane (FrankenPHP)?
Plot the memory_get_usage curve first, bisect service providers to narrow the culprit, then reset stateful singletons in Octane's hooks and clear statics.