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

An open-source, in-memory data store used as a database, cache, message broker, and queue with sub-millisecond response times.

A query that transforms rows into columns, creating a pivot table view of aggregated data.

Window Function

An SQL function that performs calculations across a set of rows related to the current row without collapsing the result set.

The default index type in most databases that organizes data in a balanced tree structure for efficient searching, sorting, and range queries.

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.

Database Connection Pooling

A technique that maintains a cache of database connections for reuse, reducing the overhead of creating new connections.

View All Databases Terms →