Increase the default value of default_statistics_target from 10 to 100,

[postgresql] / src / backend / utils / misc / postgresql.conf.sample

diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample
index 258a7d1a4f519942d23b3eef13ea54be9fbaf5d2..bf85ae083c6b03268c22250e1540408300367eb1 100644 (file)
--- a/src/backend/utils/misc/postgresql.conf.sample
+++ b/src/backend/utils/misc/postgresql.conf.sample
@@ -21,7 +21,7 @@
 # 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
@@ -60,8 +60,7 @@
 #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)
@@ -104,7 +103,7 @@
 
 # - 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
@@ -115,13 +114,6 @@
 #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
@@ -218,8 +210,9 @@
 
 # - 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
@@ -279,7 +272,7 @@
                                        #   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
@@ -322,7 +315,7 @@
 #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
@@ -363,7 +356,10 @@
 
 #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 -
@@ -423,6 +419,7 @@
 # - 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
@@ -448,7 +445,6 @@
 
 # - Other Defaults -
 
-#explain_pretty_print = on
 #dynamic_library_path = '$libdir'
 #local_preload_libraries = ''