🎁 New User? Get 20% off your first purchase with code NEWUSER20 · ⚡ Instant download · 🔒 Secure checkout Register Now →
Menu

Categories

Databases Intermediate

What is Connection Pool?

A cache of database connections that can be reused, avoiding the overhead of creating new connections for each request.

Connection pooling maintains a set of open database connections that are shared among application threads. Creating a new database connection is expensive (authentication, SSL handshake, memory allocation), so pooling dramatically improves performance.

Popular connection poolers include PgBouncer (PostgreSQL), MySQL Connector pools, and application-level pools. Key settings include minimum/maximum pool size, connection timeout, and idle timeout.

Related Terms

Full-Text Search
A technique for searching natural language text in databases using word stemming, ranking, and relevance scoring.
SQL
Structured Query Language — the standard language for managing and querying data in relational databases.
Crosstab Query
A query that transforms rows into columns, creating a pivot table view of aggregated data.
B-Tree Index
The default index type in most databases that organizes data in a balanced tree structure for efficient searching, sorting, and range queries.
EXPLAIN Plan
A database command that shows how the query planner will execute a SQL query, revealing join methods, scan types, and estimated costs.
PostgreSQL
An advanced open-source relational database known for its reliability, feature richness, and standards compliance.
 View All Databases Terms →