These settings are available in system.settings and are autogenerated from source.
postgresql_connection_attempt_timeout
Type
UInt64
Default
2
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.7 | 2 | Allow to control 'connect_timeout' parameter of PostgreSQL connection. |
Connection timeout in seconds of a single attempt to connect PostgreSQL end-point.
The value is passed as a connect_timeout parameter of the connection URL.
postgresql_connection_pool_auto_close_connection
Type
Bool
Default
0
Close connection before returning connection to the pool.
postgresql_connection_pool_retries
Type
UInt64
Default
2
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.7 | 2 | Allow to control the number of retries in PostgreSQL connection pool. |
Connection pool push/pop retries number for PostgreSQL table engine and database engine.
postgresql_connection_pool_size
Type
UInt64
Default
16
Connection pool size for PostgreSQL table engine and database engine.
postgresql_connection_pool_wait_timeout
Type
UInt64
Default
5000
Connection pool push/pop timeout on empty pool for PostgreSQL table engine and database engine. By default it will block on empty pool.