Struct PoolOptions 

pub struct PoolOptions {
    pub max_connections: Option<u32>,
    pub min_connections: Option<u32>,
    pub acquire_timeout: Option<Duration>,
    pub idle_timeout: Option<Duration>,
    pub max_lifetime: Option<Duration>,
    pub statement_timeout: Option<Duration>,
    pub idle_in_transaction_session_timeout: Option<Duration>,
}

Connection-pool configuration for the Postgres backend.

All fields are optional; unset fields fall back to sqlx defaults (e.g. max_connections = 10, no idle/lifetime caps, no session-level timeouts).

statement_timeout and idle_in_transaction_session_timeout are applied at the session level via SET on every newly-acquired connection, so they affect every query the pool serves without requiring a server-side configuration change.

Construct via PoolOptions::default() and field-assign, or pass directly to PostgresBackend::connect_with_options.

Fields

max_connections: Option<u32>

Maximum number of connections held by the pool. sqlx default: 10.

min_connections: Option<u32>

Minimum number of connections kept warm. sqlx default: 0.

acquire_timeout: Option<Duration>

Time to wait for a connection from the pool before erroring out.

idle_timeout: Option<Duration>

Drop connections idle for longer than this.

max_lifetime: Option<Duration>

Recycle connections older than this regardless of idle state.

statement_timeout: Option<Duration>

statement_timeout value applied to every connection. Aborts queries that run longer than this duration.

Note: sub-millisecond and zero durations are floored at 1 ms, because PG interprets a 0 value as “timeout disabled” — the opposite of what such a tight bound would suggest. Pass None to leave the server default in place (typically no timeout).

idle_in_transaction_session_timeout: Option<Duration>

idle_in_transaction_session_timeout value applied to every connection. Aborts transactions that sit idle for longer than this duration, releasing the connection and unblocking VACUUM.

Subject to the same sub-millisecond floor as statement_timeout.

Trait Implementations

impl Clone for PoolOptions

fn clone(&self) -> PoolOptions

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PoolOptions

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

Formats the value using the given formatter.

impl Default for PoolOptions

fn default() -> PoolOptions

Returns the “default value” for a type.