🎁 New User? Get 20% off your first purchase with code NEWUSER20 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

Materialized View
A database object that stores the precomputed result of a query, offering faster reads at the cost of periodic refresh.
Vacuum
A PostgreSQL maintenance operation that reclaims storage from dead tuples and updates statistics for the query planner.
Cursor
A database object that enables row-by-row processing of query results, useful for operations that cannot be done in bulk.
ETL (Extract, Transform, Load)
A data pipeline process that extracts data from sources, transforms it into a suitable format, and loads it into a destination system.
Window Function
An SQL function that performs calculations across a set of rows related to the current row without collapsing the result set.
Graph Database
A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.
 View All Databases Terms →