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, 1/2 RAM recommended |
temp_buffers | 2MB | Sets the maximum number of temporary buffers used by each session. | per session |
work_mem | 16MB | Sets the maximum memory to be used for query workspaces. | min 16MB, RAM / 128 recommended |
maintenance_work_mem | 64MB | Sets the maximum memory to be used for maintenance operations. | min 64MB, RAM / 32 recommeneded |
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. | |