2 # PostgreSQL configuration file
3 # -----------------------------
5 # This file consists of lines of the form
9 # (The `=' is optional.) White space is collapsed, comments are
10 # introduced by `#' anywhere on a line. The complete list of option
11 # names and allowed values can be found in the PostgreSQL
12 # documentation. Examples are:
18 # Any option can also be given as a command line switch to the
19 # postmaster, e.g., 'postmaster -c log_connections=on'. Some options
20 # can be set at run-time with the 'SET' SQL command.
23 #========================================================================
27 # Connection Parameters
32 #max_connections = 32 # 1-1024
35 #hostname_lookup = false
36 #show_source_port = false
38 #unix_socket_directory = ''
39 #unix_socket_group = ''
40 #unix_socket_permissions = 0777
44 #krb_server_keyfile = ''
51 #shared_buffers = 64 # 2*max_connections, min 16
56 # Optimizer Parameters
58 #enable_seqscan = true
59 #enable_indexscan = true
60 #enable_tidscan = true
62 #enable_nestloop = true
63 #enable_mergejoin = true
64 #enable_hashjoin = true
69 #effective_cache_size = 1000 # default in 8k pages
71 #cpu_tuple_cost = 0.01
72 #cpu_index_tuple_cost = 0.001
73 #cpu_operator_cost = 0.0025
74 #geqo_selection_bias = 2.0 # range 1.5-2.0
78 # GEQO Optimizer Parameters
81 #geqo_pool_size = 0 #default based in tables, range 128-1024
84 #geqo_random_seed = -1 # auto-compute seed
88 # Write-ahead log (WAL)
90 #wal_buffers = 8 # min 4
91 #wal_files = 0 # range 0-64
92 #wal_sync_method = fsync # fsync or fdatasync or open_sync or open_datasync
93 # Note: default wal_sync_method varies across platforms
94 #wal_debug = 0 # range 0-16
95 #commit_delay = 0 # range 0-100000
96 #commit_siblings = 5 # range 1-1000
97 #checkpoint_segments = 3 # in logfile segments (16MB each), min 1
98 #checkpoint_timeout = 300 # in seconds, range 30-3600
106 #log_connections = false
107 #log_timestamp = false
110 #debug_level = 0 # range 0-16
112 #debug_print_query = false
113 #debug_print_parse = false
114 #debug_print_rewritten = false
115 #debug_print_plan = false
116 #debug_pretty_print = false
118 #ifdef USE_ASSERT_CHECKING
119 #debug_assertions = true
127 #syslog = 0 # range 0-2
128 #syslog_facility = 'LOCAL0'
129 #syslog_ident = 'postgres'
136 #show_parser_stats = false
137 #show_planner_stats = false
138 #show_executor_stats = false
139 #show_query_stats = false
140 #ifdef BTREE_BUILD_STATS
141 #show_btree_build_stats = false
148 #trace_notify = false
151 #trace_userlocks = false
152 #trace_spinlocks = false
153 #debug_deadlocks = false
154 #trace_lock_oidmin = 16384
155 #trace_lock_table = 0
162 #sql_inheritance = true
163 #australian_timezones = false
164 #deadlock_timeout = 1000
165 #max_expr_depth = 10000 # min 10