|
79 | 79 | #cpu_tuple_cost = 0.01 |
80 | 80 | #cpu_index_tuple_cost = 0.001 |
81 | 81 | #cpu_operator_cost = 0.0025 |
82 | | -#geqo_selection_bias = 2.0 # range 1.5-2.0 |
83 | 82 |
|
84 | 83 |
|
85 | 84 | # |
86 | 85 | #GEQO Optimizer Parameters |
87 | 86 | # |
| 87 | +#geqo_selection_bias = 2.0 # range 1.5-2.0 |
88 | 88 | #geqo_threshold = 11 |
89 | | -#geqo_pool_size = 0#default based on #tables in query, range 128-1024 |
| 89 | +#geqo_pool_size = 0 #default based on #tables in query, range 128-1024 |
90 | 90 | #geqo_effort = 1 |
91 | 91 | #geqo_generations = 0 |
92 | | -#geqo_random_seed = -1 # auto-compute seed |
| 92 | +#geqo_random_seed = -1# auto-compute seed |
93 | 93 |
|
94 | 94 |
|
95 | 95 | # |
96 | 96 | #Write-ahead log (WAL) |
97 | 97 | # |
98 | 98 | #wal_files = 0 # range 0-64 |
99 | | -#wal_sync_method = fsync # fsync or fdatasync or open_sync or open_datasync |
| 99 | +#wal_sync_method = fsync# fsync or fdatasync or open_sync or open_datasync |
100 | 100 | # Note: default wal_sync_method varies across platforms |
101 | | -#wal_debug = 0 # range 0-16 |
102 | | -#commit_delay = 0 # range 0-100000 |
103 | | -#commit_siblings = 5 # range 1-1000 |
104 | | -#checkpoint_segments = 3 # in logfile segments (16MB each), min 1 |
105 | | -#checkpoint_timeout = 300 # in seconds, range 30-3600 |
| 101 | +#wal_debug = 0# range 0-16 |
| 102 | +#commit_delay = 0# range 0-100000 |
| 103 | +#commit_siblings = 5# range 1-1000 |
| 104 | +#checkpoint_segments = 3# in logfile segments (16MB each), min 1 |
| 105 | +#checkpoint_timeout = 300# in seconds, range 30-3600 |
106 | 106 |
|
107 | 107 |
|
108 | 108 | # |
|