Recommended PostgreSQL parameters
Review the recommended parameters for effective performance with PostgreSQL.
| Parameter | Value | Reference |
|---|---|---|
| Write Ahead Log (WAL) parameters | ||
checkpoint_completion_target |
0.9 | For more information, see Write Ahead Log (WAL) parameters. |
max_wal_size |
4 GB | |
min_wal_size |
1 GB | |
wal_buffers |
16 MB | |
| Query planning parameters | ||
default_statistics_target |
100 | For more information, see query planning parameters. |
effective_cache_size
|
74496 MB | |
random_page_cost |
1.1 | |
| Resource consumption parameters | ||
effective_io_concurrency |
200 | For more information, see resource consumption parameters. |
maintenance_work_mem
|
2 GB | |
max_parallel_workers
|
16 | |
max_parallel_maintenance_workers |
4 | |
max_parallel_workers_per_gather |
4 | |
max_worker_processes |
16 | |
shared_buffers |
24832 MB | |
work_mem |
31784 KB | |
| Connections and authentication parameters | ||
listen_addresses |
'*' | For more information, see connections and authentication parameters. |
max_connections |
1024 | |
ssl
|
on |
For more information about how PostgreSQL uses SSL and generates certificates, see secure TCP/IP connections with SSL. For more information about how to configure IBM® Sterling™ Order Management System Software to use PostgreSQL over SSL via JDBC, see configuring PostgreSQL server for SSL. |
| Lock management parameter | ||
max_locks_per_transaction |
1024 | For more information, see lock management parameters. |
| Client connection defaults parameter | ||
shared_preload_libraries |
For more information, see client connection defaults parameters. | |
| pg_stat_statements parameter | ||
pg_stat_statements.track
|
all | For more information, see pg_stat_statements parameter and enabling pg_stat_statements. |
For guidelines on PostgreSQL tuning, see Additional resources.