# take effect.
#
# Any parameter can also be given as a command-line option to the server, e.g.,
-# "postgres -c log_connections=on". Some paramters can be changed at run time
+# "postgres -c log_connections=on". Some parameters can be changed at run time
# with the "SET" SQL command.
#
# Memory units: kB = kilobytes MB = megabytes GB = gigabytes
#port = 5432 # (change requires restart)
#max_connections = 100 # (change requires restart)
# Note: Increasing max_connections costs ~400 bytes of shared memory per
-# connection slot, plus lock space (see max_locks_per_transaction). You might
-# also need to raise shared_buffers to support more connections.
+# connection slot, plus lock space (see max_locks_per_transaction).
#superuser_reserved_connections = 3 # (change requires restart)
#unix_socket_directory = '' # (change requires restart)
#unix_socket_group = '' # (change requires restart)
# - Memory -
-#shared_buffers = 32MB # min 128kB or max_connections*16kB
+#shared_buffers = 32MB # min 128kB
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 5 # can be 0 or more
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 2MB # min 100kB
-# - Free Space Map -
-
-#max_fsm_pages = 204800 # min max_fsm_relations*16, 6 bytes each
- # (change requires restart)
-#max_fsm_relations = 1000 # min 100, ~70 bytes each
- # (change requires restart)
-
# - Kernel Resource Usage -
#max_files_per_process = 1000 # min 25
# - Other Planner Options -
-#default_statistics_target = 10 # range 1-1000
+#default_statistics_target = 100 # range 1-10000
#constraint_exclusion = off
+#cursor_tuple_fraction = 0.1 # range 0.0-1.0
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables collapsing of explicit
# JOIN clauses
# warning
# error
-#log_min_messages = notice # values in order of decreasing detail:
+#log_min_messages = warning # values in order of decreasing detail:
# debug5
# debug4
# debug3
#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
-#debug_pretty_print = off
+#debug_pretty_print = on
#log_checkpoints = off
#log_connections = off
#log_disconnections = off
#track_activities = on
#track_counts = on
+#track_functions = none # none, pl, all
+#track_activity_query_size = 1024
#update_process_title = on
+#stats_temp_directory = 'pg_stat_tmp'
# - Statistics Monitoring -
# - Locale and Formatting -
#datestyle = 'iso, mdy'
+#intervalstyle = 'postgres'
#timezone = unknown # actually, defaults to TZ environment
# setting
#timezone_abbreviations = 'Default' # Select the set of available time zone
# - Other Defaults -
-#explain_pretty_print = on
#dynamic_library_path = '$libdir'
#local_preload_libraries = ''
#backslash_quote = safe_encoding # on, off, or safe_encoding
#default_with_oids = off
#escape_string_warning = on
-#standard_conforming_strings = off
#regex_flavor = advanced # advanced, extended, or basic
#sql_inheritance = on
+#standard_conforming_strings = off
+#synchronize_seqscans = on
# - Other Platforms and Clients -