|
47 | 47 | # |
48 | 48 | #Shared Memory Size |
49 | 49 | # |
50 | | -#shared_buffers = 64# min max_connections*2 or 16, 8KB each |
51 | | -#max_locks_per_transaction = 64# min 10 |
52 | | -#wal_buffers = 8# min 4,typically8KB each |
| 50 | +#shared_buffers = 64# min16, at leastmax_connections*2, 8KB each |
| 51 | +#max_locks_per_transaction = 64# min 10, ~260*max_connections bytes each |
| 52 | +#wal_buffers = 8# min 4, 8KB each |
53 | 53 | # fsm = free space map |
54 | 54 | #max_fsm_relations = 1000# min 100, ~50 bytes each |
55 | 55 | #max_fsm_pages = 20000# min max_fsm_relations*16, 6 bytes each |
| 56 | +# note: increasing max_connections also costs about 500 bytes each, |
| 57 | +# in addition to costs from shared_buffers and max_locks_per_transaction. |
| 58 | + |
56 | 59 |
|
57 | 60 | # |
58 | 61 | #Non-shared Memory Sizes |
|