Page History
...
| Warning |
|---|
This configuration may change according to real usage needs. Example below shows the minimal configuration for single server installation. |
Name | Value | Description | Note |
|---|---|---|---|
max_connections | 50 | Sets the maximum number of concurrent connections. |
|
shared_buffers | 512MB | Sets the number of shared memory buffers used by the server. | min 1/4 RAM |
temp_buffers | 2MB | Sets the maximum number of temporary buffers used by each session. | per session |
work_mem | 10MB | Sets the maximum memory to be used for query workspaces. | per client connection |
maintenance_work_mem | 64MB | Sets the maximum memory to be used for maintenance operations. |
|
max_stack_depth | 2MB | Sets the maximum stack depth, in kilobytes. |
|
wal_buffers | 512kB | Sets the number of disk-page buffers in shared memory for WAL. |
|
effective_cache_size | 512MB | Sets the planner's assumption about the size of the disk cache. |
|
log_statement | none | Sets the type of statements logged. |
|
| autovacuum | on | Starts the autovacuum subprocess. | |
| autovacuum_analyze_scale_factor | 0.05 | Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples. | |
| autovacuum_analyze_threshold | 10 | Minimum number of tuple inserts, updates, or deletes prior to analyze. | |
| autovacuum_freeze_max_age | 200000000 | Age at which to autovacuum a table to prevent transaction ID wraparound. | |
| autovacuum_max_workers | 5 | Sets the maximum number of simultaneously running autovacuum worker processes. | |
| autovacuum_multixact_freeze_max_age | 400000000 | Multixact age at which to autovacuum a table to prevent multixact wraparound. | |
| autovacuum_naptime | 15s | Time to sleep between autovacuum runs. | |
| autovacuum_vacuum_cost_delay | 10ms | Vacuum cost delay in milliseconds, for autovacuum. | |
| autovacuum_vacuum_cost_limit | 1000 | Vacuum cost amount available before napping, for autovacuum. | |
| autovacuum_vacuum_scale_factor | 0.1 | Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. | |
| autovacuum_vacuum_threshold | 25 | Minimum number of tuple updates or deletes prior to vacuum. |
| Info |
|---|
We recommend set the |
...
Overview
Content Tools