|
18 | 18 | # Any option can also be given as a command line switch to the |
19 | 19 | # postmaster, e.g., 'postmaster -c log_connections=on'. Some options |
20 | 20 | # can be set at run-time with the 'SET' SQL command. |
21 | | - |
22 | | - |
23 | | -enable_seqscan = true |
24 | | -enable_indexscan = true |
25 | | -enable_tidscan = true |
26 | | -enable_sort = true |
27 | | -enable_nestloop = true |
28 | | -enable_mergejoin = true |
29 | | -enable_hashjoin = true |
30 | | - |
31 | | -ksqo = izer, false |
32 | | -geqo = true |
33 | | - |
34 | | -tcpip_socket = false |
35 | | -ssl = false |
36 | | -fsync = true |
37 | | -silent_mode = false |
38 | | - |
39 | | -log_connections = false |
40 | | -log_timestamp = false |
41 | | -log_pid = false |
42 | | - |
43 | | -#ifdef USE_ASSERT_CHECKING |
44 | | -debug_assertions = true |
45 | | -#endif |
46 | | - |
47 | | -debug_print_query = false |
48 | | -debug_print_parse = false |
49 | | -debug_print_rewritten = false |
50 | | -debug_print_plan = false |
51 | | -debug_pretty_print = false |
52 | | - |
53 | | -show_parser_stats = false |
54 | | -show_planner_stats = false |
55 | | -show_executor_stats = false |
56 | | -show_query_stats = false |
57 | | -#ifdef BTREE_BUILD_STATS |
58 | | -show_btree_build_stats = false |
59 | | -#endif |
60 | | - |
61 | | -trace_notify = false |
62 | | - |
63 | | -#ifdef LOCK_DEBUG |
64 | | -trace_locks = false |
65 | | -trace_userlocks = false |
66 | | -trace_spinlocks = false |
67 | | -debug_deadlocks = false |
68 | | -#endif |
69 | | - |
70 | | -hostname_lookup = false |
71 | | -show_source_port = false |
72 | | - |
73 | | -sql_inheritance = true |
74 | | - |
75 | | -{NULL, 0, NULL, false} |
76 | | -}; |
77 | | - |
78 | | - |
79 | | -static struct config_int |
80 | | -ConfigureNamesInt[] = |
81 | | -{ |
82 | | -geqo_threshold = PGC_USERSET, &geqo_rels, |
83 | | - DEFAULT_GEQO_RELS, 2, INT_MAX |
84 | | -geqo_pool_size = PGC_USERSET, &Geqo_pool_size, |
85 | | - DEFAULT_GEQO_POOL_SIZE, 0, MAX_GEQO_POOL_SIZE |
86 | | -geqo_effort = PGC_USERSET, &Geqo_effort, |
87 | | - 1, 1, INT_MAX |
88 | | -geqo_generations = PGC_USERSET, &Geqo_generations, |
89 | | - 0, 0, INT_MAX |
90 | | -geqo_random_seed = PGC_USERSET, &Geqo_random_seed, |
91 | | - -1, INT_MIN, INT_MAX |
92 | | - |
93 | | -deadlock_timeout = PGC_POSTMASTER, &DeadlockTimeout, |
94 | | - 1000, 0, INT_MAX |
95 | | - |
96 | | -#ifdef ENABLE_SYSLOG |
97 | | -syslog = PGC_SIGHUP, &Use_syslog, |
98 | | - 0, 0, 2 |
99 | | -#endif |
100 | | - |
101 | | -/* |
102 | | - * Note: There is some postprocessing done in PostmasterMain() to |
103 | | - * make sure the buffers are at least twice the number of |
104 | | - * backends, so the constraints here are partially unused. |
105 | | - */ |
106 | | -max_connections = PGC_POSTMASTER, &MaxBackends, |
107 | | - DEF_MAXBACKENDS, 1, MAXBACKENDS |
108 | | -shared_buffers = PGC_POSTMASTER, &NBuffers, |
109 | | - DEF_NBUFFERS, 16, INT_MAX |
110 | | -port = PGC_POSTMASTER, &PostPortNumber, |
111 | | - DEF_PGPORT, 1, 65535 |
112 | | - |
113 | | -sort_mem = PGC_USERSET, &SortMem, |
114 | | - 512, 1, INT_MAX |
115 | | - |
116 | | -debug_level = PGC_USERSET, &DebugLvl, |
117 | | - 0, 0, 16 |
118 | | - |
119 | | -#ifdef LOCK_DEBUG |
120 | | -trace_lock_oidmin = PGC_SUSET, &Trace_lock_oidmin, |
121 | | - BootstrapObjectIdData, 1, INT_MAX |
122 | | -trace_lock_table = PGC_SUSET, &Trace_lock_table, |
123 | | - 0, 0, INT_MAX |
124 | | -#endif |
125 | | -max_expr_depth = PGC_USERSET, &max_expr_depth, |
126 | | - DEFAULT_MAX_EXPR_DEPTH, 10, INT_MAX |
127 | | - |
128 | | -unix_socket_permissions = PGC_POSTMASTER, &Unix_socket_permissions, |
129 | | - 0777, 0000, 0777 |
130 | | - |
131 | | -checkpoint_timeout",PGC_POSTMASTER,&CheckPointTimeout, |
132 | | - 300, 30, 1800 |
133 | | - |
134 | | -wal_buffers",PGC_POSTMASTER,&XLOGbuffers, |
135 | | - 8, 4, INT_MAX |
136 | | - |
137 | | -wal_files",PGC_POSTMASTER,&XLOGfiles, |
138 | | - 0, 0, 64 |
139 | | - |
140 | | -wal_debug",PGC_SUSET,&XLOG_DEBUG, |
141 | | - 0, 0, 16 |
142 | | - |
143 | | -commit_delay",PGC_USERSET,&CommitDelay, |
144 | | - 5, 0, 1000 |
145 | | - |
146 | | - {NULL, 0, NULL, 0, 0, 0} |
147 | | -}; |
148 | | - |
149 | | - |
150 | | -static struct config_real |
151 | | -ConfigureNamesReal[] = |
152 | | -{ |
153 | | - effective_cache_size = PGC_USERSET, &effective_cache_size, |
154 | | - DEFAULT_EFFECTIVE_CACHE_SIZE, 0, DBL_MAX |
155 | | - random_page_cost = PGC_USERSET, &random_page_cost, |
156 | | - DEFAULT_RANDOM_PAGE_COST, 0, DBL_MAX |
157 | | - cpu_tuple_cost = PGC_USERSET, &cpu_tuple_cost, |
158 | | - DEFAULT_CPU_TUPLE_COST, 0, DBL_MAX |
159 | | - cpu_index_tuple_cost = PGC_USERSET, &cpu_index_tuple_cost, |
160 | | - DEFAULT_CPU_INDEX_TUPLE_COST, 0, DBL_MAX |
161 | | - cpu_operator_cost = PGC_USERSET, &cpu_operator_cost, |
162 | | - DEFAULT_CPU_OPERATOR_COST, 0, DBL_MAX |
163 | | - |
164 | | - geqo_selection_bias = PGC_USERSET, &Geqo_selection_bias, |
165 | | - DEFAULT_GEQO_SELECTION_BIAS, MIN_GEQO_SELECTION_BIAS, MAX_GEQO_SELECTION_BIAS |
166 | | - |
167 | | - {NULL, 0, NULL, 0.0, 0.0, 0.0} |
168 | | -}; |
169 | | - |
170 | | - |
171 | | -static struct config_string |
172 | | -ConfigureNamesString[] = |
173 | | -{ |
174 | | -krb_server_keyfile = PGC_POSTMASTER, &pg_krb_server_keyfile, |
175 | | - PG_KRB_SRVTAB, NULL |
176 | | - |
177 | | -unix_socket_group = PGC_POSTMASTER, &Unix_socket_group, |
178 | | - " = NULL |
179 | | - |
180 | | -#ifdef ENABLE_SYSLOG |
181 | | -syslog_facility = PGC_POSTMASTER, &Syslog_facility, |
182 | | -"LOCAL0 = check_facility |
183 | | -syslog_ident = PGC_POSTMASTER, &Syslog_ident, |
184 | | -"postgres = NULL |
185 | | -#endif |
186 | | - |
187 | | -unix_socket_directory", PGC_POSTMASTER, &UnixSocketDir, |
188 | | - " = NULL |
189 | | - |
190 | | -virtual_host", PGC_POSTMASTER,&VirtualHost, |
191 | | - " = NULL |
192 | | - |
193 | | -{NULL, 0, NULL, NULL, NULL} |
194 | | -}; |
195 | | - |
196 | | - |