Connection slots reserved for superusers.
At a glance
| Property | Value |
|---|---|
| Parameter | superuser_reserved_connections |
| Category | Connections |
| Default | 3 |
| Value type | boolean / enum / numeric |
| Change scope | Restart required |
What it does
Reserves a number of connection slots out of max_connections for superusers, so an administrator can always get in even when the server is saturated.
How to apply a change
Requires a full server restart (postmaster context). Set it in postgresql.conf and restart PostgreSQL.
Inspect the current value and source with SHOW superuser_reserved_connections; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'superuser_reserved_connections';.
Tuning guidance
Keep at least 3. If you use reserved_connections (PG16+) for monitoring roles, account for both pools when sizing max_connections.