Connection Pooling

Definitions

1. Maintaining a cache of reusable database connections instead of opening a new connection for each request. Dramatically reduces latency (TCP handshakes, TLS negotiation, authentication) and prevents overwhelming the database with too many concurrent connections.

   In plain English: Keeping a set of database connections ready to reuse instead of creating a brand new one every time.

   Example: "Set the pool size to 20 connections — without pooling, each request was spending 50ms just on the PostgreSQL handshake."

Related Terms

• Tombstone
• Write-Ahead Log
• N+1 Query Problem
• Islands Architecture
• Debounce
• Throttle
• Load Shedding
• Query Plan
• Index Scan vs Seq Scan
• Upsert
• Partitioning
• Thread Pool
• Query Cache
• Query Optimizer