2 # PostgreSQL configuration file
3 # -----------------------------
5 # This file consists of lines of the form:
9 # (The '=' is optional.) White space may be used. Comments are introduced
10 # with '#' anywhere on a line. The complete list of option names and
11 # allowed values can be found in the PostgreSQL documentation. The
12 # commented-out settings shown in this file represent the default values.
14 # Any option can also be given as a command line switch to the
15 # postmaster, e.g. 'postmaster -c log_connections=on'. Some options
16 # can be changed at run-time with the 'SET' SQL command.
18 # This file is read on postmaster startup and when the postmaster
19 # receives a SIGHUP. If you edit the file on a running system, you have
20 # to SIGHUP the postmaster for the changes to take effect, or use
24 #========================================================================
28 # Connection Parameters
34 #superuser_reserved_connections = 2
38 #unix_socket_directory = ''
39 #unix_socket_group = ''
40 #unix_socket_permissions = 0777 # octal
44 #krb_server_keyfile = ''
50 #shared_buffers = 64 # min max_connections*2 or 16, 8KB each
51 #max_fsm_relations = 1000 # min 10, fsm is free space map, ~40 bytes
52 #max_fsm_pages = 10000 # min 1000, fsm is free space map, ~6 bytes
53 #max_locks_per_transaction = 64 # min 10
54 #wal_buffers = 8 # min 4, typically 8KB each
57 # Non-shared Memory Sizes
59 #sort_mem = 1024 # min 64, size in KB
60 #vacuum_mem = 8192 # min 1024, size in KB
64 # Write-ahead log (WAL)
66 #checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
67 #checkpoint_timeout = 300 # range 30-3600, in seconds
68 #checkpoint_warning = 30 # 0 is off, in seconds
70 #commit_delay = 0 # range 0-100000, in microseconds
71 #commit_siblings = 5 # range 1-1000
74 #wal_sync_method = fsync # the default varies across platforms:
75 # # fsync, fdatasync, open_sync, or open_datasync
76 #wal_debug = 0 # range 0-16
80 # Optimizer Parameters
82 #enable_seqscan = true
83 #enable_indexscan = true
84 #enable_tidscan = true
86 #enable_hashagg = true
87 #enable_nestloop = true
88 #enable_mergejoin = true
89 #enable_hashjoin = true
91 #effective_cache_size = 1000 # typically 8KB each
92 #random_page_cost = 4 # units are one sequential page fetch cost
93 #cpu_tuple_cost = 0.01 # (same)
94 #cpu_index_tuple_cost = 0.001 # (same)
95 #cpu_operator_cost = 0.0025 # (same)
97 #from_collapse_limit = 8
98 #join_collapse_limit = 8 # 1 disables collapsing of explicit JOINs
100 #default_statistics_target = 10 # range 1-1000
103 # GEQO Optimizer Parameters
106 #geqo_selection_bias = 2.0 # range 1.5-2.0
108 #geqo_pool_size = 0 # default based on tables in statement,
111 #geqo_generations = 0
112 #geqo_random_seed = -1 # auto-compute seed
118 #log_min_messages = notice # Values, in order of decreasing detail:
119 # debug5, debug4, debug3, debug2, debug1,
120 # info, notice, warning, error, log, fatal,
122 #client_min_messages = notice # Values, in order of decreasing detail:
123 # debug5, debug4, debug3, debug2, debug1,
124 # log, info, notice, warning, error,
128 #log_connections = false
129 #log_hostname = false
130 #log_source_port = false
132 #log_statement = false
133 #log_duration = false
134 #log_timestamp = false
136 #log_min_error_statement = error # Values in order of increasing severity:
137 # debug5, debug4, debug3, debug2, debug1,
138 # info, notice, warning, error, panic(off)
140 #debug_print_parse = false
141 #debug_print_rewritten = false
142 #debug_print_plan = false
143 #debug_pretty_print = false
145 #explain_pretty_print = true
147 # requires USE_ASSERT_CHECKING
148 #debug_assertions = true
154 #syslog = 0 # range 0-2
155 #syslog_facility = 'LOCAL0'
156 #syslog_ident = 'postgres'
162 #log_parser_stats = false
163 #log_planner_stats = false
164 #log_executor_stats = false
165 #log_statement_stats = false
167 # requires BTREE_BUILD_STATS
168 #log_btree_build_stats = false
172 # Access statistics collection
174 #stats_start_collector = true
175 #stats_reset_on_server_start = true
176 #stats_command_string = false
177 #stats_row_level = false
178 #stats_block_level = false
184 #trace_notify = false
186 # requires LOCK_DEBUG
188 #trace_userlocks = false
189 #trace_lwlocks = false
190 #debug_deadlocks = false
191 #trace_lock_oidmin = 16384
192 #trace_lock_table = 0
199 #dynamic_library_path = '$libdir'
200 #search_path = '$user,public'
201 #datestyle = 'iso, us'
202 #timezone = unknown # actually, defaults to TZ environment setting
203 #australian_timezones = false
204 #client_encoding = sql_ascii # actually, defaults to database encoding
205 #authentication_timeout = 60 # 1-600, in seconds
206 #deadlock_timeout = 1000 # in milliseconds
207 #default_transaction_isolation = 'read committed'
208 #extra_float_digits = 0 # min -15, max 2
209 #max_expr_depth = 10000 # min 10
210 #max_files_per_process = 1000 # min 25
211 #password_encryption = true
212 #sql_inheritance = true
213 #transform_null_equals = false
214 #statement_timeout = 0 # 0 is disabled, in milliseconds
215 #db_user_namespace = false