aboutsummaryrefslogtreecommitdiff
path: root/src/backend/utils/misc/postgresql.conf.sample
diff options
context:
space:
mode:
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
-rw-r--r--src/backend/utils/misc/postgresql.conf.sample150
1 files changed, 150 insertions, 0 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample
index 40a4346fe1c..223360693b4 100644
--- a/src/backend/utils/misc/postgresql.conf.sample
+++ b/src/backend/utils/misc/postgresql.conf.sample
@@ -18,3 +18,153 @@
# Any option can also be given as a command line switch to the
# postmaster, e.g., 'postmaster -c log_connections=on'. Some options
# can be set at run-time with the 'SET' SQL command.
+
+
+#========================================================================
+
+
+#
+# Connection Parameters
+#
+#tcpip_socket = false
+#ssl = false
+
+#max_connections = 32 # 1-1024
+
+#port = 5432
+#hostname_lookup = false
+#show_source_port = false
+
+#unix_socket_directory = ""
+#unix_socket_group = ""
+#unix_socket_permissions = 0777
+
+#virtual_host = ""
+
+#krb_server_keyfile = ""
+
+
+#
+# Performance
+#
+#sort_mem = 512
+#shared_buffers = 2*max_connections # min 16
+#fsync = true
+
+
+#
+# Optimizer Parameters
+#
+#enable_seqscan = true
+#enable_indexscan = true
+#enable_tidscan = true
+#enable_sort = true
+#enable_nestloop = true
+#enable_mergejoin = true
+#enable_hashjoin = true
+
+#ksqo = false
+#geqo = true
+
+#effective_cache_size = 1000 # default in 8k pages
+#random_page_cost = 4
+#cpu_tuple_cost = 0.01
+#cpu_index_tuple_cost = 0.001
+#cpu_operator_cost = 0.0025
+#geqo_selection_bias = 2.0 # range 1.5-2.0
+
+
+#
+# GEQO Optimizer Parameters
+#
+#geqo_threshold = 11
+#geqo_pool_size = 0 #default based in tables, range 128-1024
+#geqo_effort = 1
+#geqo_generations = 0
+#geqo_random_seed = -1 # auto-compute seed
+
+
+#
+# Inheritance
+#
+#sql_inheritance = true
+
+
+#
+# Deadlock
+#
+#deadlock_timeout = 1000
+
+
+#
+# Expression Depth Limitation
+#
+#max_expr_depth = 10000 # min 10
+
+
+#
+# Write-ahead log (WAL)
+#
+#wal_buffers = 8 # min 4
+#wal_files = 0 # range 0-64
+#wal_debug = 0 # range 0-16
+#commit_delay = 5 # range 0-1000
+#checkpoint_timeout = 300 # range 30-1800
+
+
+#
+# Debug display
+#
+#silent_mode = false
+
+#log_connections = false
+#log_timestamp = false
+#log_pid = false
+
+#debug_level = 0 # range 0-16
+
+#debug_print_query = false
+#debug_print_parse = false
+#debug_print_rewritten = false
+#debug_print_plan = false
+#debug_pretty_print = false
+
+#ifdef USE_ASSERT_CHECKING
+#debug_assertions = true
+#endif
+
+
+#
+# Syslog
+#
+#ifdef ENABLE_SYSLOG
+#syslog = 0 # range 0-2
+#syslog_facility = "LOCAL0"
+#syslog_ident = "postgres"
+#endif
+
+
+#
+# Statistics
+#
+#show_parser_stats = false
+#show_planner_stats = false
+#show_executor_stats = false
+#show_query_stats = false
+#ifdef BTREE_BUILD_STATS
+#show_btree_build_stats = false
+#endif
+
+
+#
+# Lock Tracing
+#
+#trace_notify = false
+#ifdef LOCK_DEBUG
+#trace_locks = false
+#trace_userlocks = false
+#trace_spinlocks = false
+#debug_deadlocks = false
+#trace_lock_oidmin = 16384
+#trace_lock_table = 0
+#endif