From 890a012d0a9346ea160cd9f2c435e2c73429204e Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 18 Feb 2002 06:42:54 +0000 Subject: [PATCH] Reorder postgresql.conf WAL section to be clearer. --- src/backend/utils/misc/postgresql.conf.sample | 52 ++++++++++--------- 1 file changed, 28 insertions(+), 24 deletions(-) diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 071e814454..7cb15cd4ae 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -44,31 +44,34 @@ # # Shared Memory Size # -#shared_buffers = 64 # 2*max_connections, min 16 -#max_fsm_relations = 100 # min 10, fsm is free space map -#max_fsm_pages = 10000 # min 1000, fsm is free space map -#max_locks_per_transaction = 64 # min 10 -#wal_buffers = 8 # min 4 +#shared_buffers = 64 # 2*max_connections, min 16 +#max_fsm_relations = 100 # min 10, fsm is free space map +#max_fsm_pages = 10000 # min 1000, fsm is free space map +#max_locks_per_transaction = 64 # min 10 +#wal_buffers = 8 # min 4 # # Non-shared Memory Sizes # -#sort_mem = 512 # min 32 -#vacuum_mem = 8192 # min 1024 +#sort_mem = 512 # min 32 +#vacuum_mem = 8192 # min 1024 # # Write-ahead log (WAL) # -#wal_files = 0 # range 0-64 -#wal_sync_method = fsync # the default varies across platforms: -# # fsync, fdatasync, open_sync, or open_datasync -#wal_debug = 0 # range 0-16 -#commit_delay = 0 # range 0-100000 -#commit_siblings = 5 # range 1-1000 -#checkpoint_segments = 3 # in logfile segments (16MB each), min 1 -#checkpoint_timeout = 300 # in seconds, range 30-3600 +#checkpoint_segments = 3 # in logfile segments (16MB each), min 1 +#checkpoint_timeout = 300 # in seconds, range 30-3600 +# +#wal_files = 0 # range 0-64 +# +#commit_delay = 0 # range 0-100000 +#commit_siblings = 5 # range 1-1000 +# #fsync = true +#wal_sync_method = fsync # the default varies across platforms: +# # fsync, fdatasync, open_sync, or open_datasync +#wal_debug = 0 # range 0-16 # @@ -84,7 +87,7 @@ #ksqo = false -#effective_cache_size = 1000 # default in 8k pages +#effective_cache_size = 1000 # default in 8k pages #random_page_cost = 4 #cpu_tuple_cost = 0.01 #cpu_index_tuple_cost = 0.001 @@ -95,12 +98,13 @@ # GEQO Optimizer Parameters # #geqo = true -#geqo_selection_bias = 2.0 # range 1.5-2.0 +#geqo_selection_bias = 2.0 # range 1.5-2.0 #geqo_threshold = 11 -#geqo_pool_size = 0 # default based on #tables in query, range 128-1024 +#geqo_pool_size = 0 # default based on tables in query, + # range 128-1024 #geqo_effort = 1 #geqo_generations = 0 -#geqo_random_seed = -1 # auto-compute seed +#geqo_random_seed = -1 # auto-compute seed # @@ -112,7 +116,7 @@ #log_timestamp = false #log_pid = false -#debug_level = 0 # range 0-16 +#debug_level = 0 # range 0-16 #debug_print_query = false #debug_print_parse = false @@ -128,7 +132,7 @@ # Syslog # # requires ENABLE_SYSLOG -#syslog = 0 # range 0-2 +#syslog = 0 # range 0-2 #syslog_facility = 'LOCAL0' #syslog_ident = 'postgres' @@ -174,11 +178,11 @@ # #dynamic_library_path = '$libdir' #australian_timezones = false -#authentication_timeout = 60 # min 1, max 600 +#authentication_timeout = 60 # min 1, max 600 #deadlock_timeout = 1000 #default_transaction_isolation = 'read committed' -#max_expr_depth = 10000 # min 10 -#max_files_per_process = 1000 # min 25 +#max_expr_depth = 10000 # min 10 +#max_files_per_process = 1000 # min 25 #password_encryption = false #sql_inheritance = true #transform_null_equals = false -- 2.40.0