Struct PostgresPoolConfig 

pub struct PostgresPoolConfig {
    pub max_connections: u32,
    pub min_connections: u32,
    pub idle_timeout: Duration,
    pub max_lifetime: Duration,
    pub acquire_timeout: Duration,
    pub statement_timeout: Duration,
}

Configuration for PostgreSQL connection pool tuning.

These parameters control how sqlx manages the underlying connection pool. All fields have sensible defaults suitable for moderate production load.

Recommended PostgreSQL server settings

For production workloads, tune these postgresql.conf knobs alongside the pool parameters:

PostgreSQL setting	Recommended value	Notes
max_connections	100 - 200	Must exceed pool max_connections
shared_buffers	25% of RAM	Main query cache
work_mem	4 - 16 MB	Per-sort/hash memory
idle_in_transaction_session_timeout	30s	Kill idle-in-transaction sessions
statement_timeout	30s	Server-side query timeout
tcp_keepalives_idle	60	Seconds before TCP keepalive probes
tcp_keepalives_interval	10	Seconds between probes
tcp_keepalives_count	6	Failed probes before disconnect

Fields

max_connections: u32

Maximum number of connections in the pool (default: 10).

min_connections: u32

Minimum number of idle connections to maintain (default: 2).

idle_timeout: Duration

Time a connection may sit idle before being closed (default: 300s).

max_lifetime: Duration

Maximum lifetime of a connection before it is recycled (default: 1800s).

acquire_timeout: Duration

How long to wait when acquiring a connection from the pool (default: 5s).

statement_timeout: Duration

Statement timeout set on each new connection via SET statement_timeout (default: 30s). Prevents runaway queries.

Trait Implementations

impl Clone for PostgresPoolConfig

fn clone(&self) -> PostgresPoolConfig

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for PostgresPoolConfig

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Default for PostgresPoolConfig

fn default() -> Self

Returns the “default value” for a type.