|
45 | 45 | #Shared Memory Size
|
46 | 46 | #
|
47 | 47 | #shared_buffers = 64 # 2*max_connections, min 16
|
48 |
| -#max_fsm_relations = 100 # min 10 |
49 |
| -#max_fsm_pages = 10000 # min 1000 |
| 48 | +#max_fsm_relations = 100 # min 10, fsm is free space map |
| 49 | +#max_fsm_pages = 10000 # min 1000, fsm is free space map |
50 | 50 | #max_locks_per_transaction = 64 # min 10
|
51 | 51 | #wal_buffers = 8 # min 4
|
52 | 52 |
|
53 | 53 | #
|
54 |
| -#Performance |
| 54 | +#Non-shared Memory Sizes |
55 | 55 | #
|
56 | 56 | #sort_mem = 512 # min 32
|
57 | 57 | #vacuum_mem = 8192 # min 1024
|
58 |
| -#fsync = true |
59 | 58 |
|
60 | 59 |
|
61 | 60 | #
|
62 | 61 | #Write-ahead log (WAL)
|
63 | 62 | #
|
64 | 63 | #wal_files = 0 # range 0-64
|
65 |
| -#wal_sync_method = fsync #fsync or fdatasync or open_sync or open_datasync |
66 |
| -# Note: default wal_sync_method varies across platforms |
| 64 | +#wal_sync_method = fsync #the default varies across platforms: |
| 65 | +# # fsync, fdatasync, open_sync, or open_datasync |
67 | 66 | #wal_debug = 0 # range 0-16
|
68 | 67 | #commit_delay = 0 # range 0-100000
|
69 | 68 | #commit_siblings = 5 # range 1-1000
|
70 | 69 | #checkpoint_segments = 3 # in logfile segments (16MB each), min 1
|
71 | 70 | #checkpoint_timeout = 300 # in seconds, range 30-3600
|
| 71 | +#fsync = true |
72 | 72 |
|
73 | 73 |
|
74 | 74 | #
|
|