|
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 | # |
|