Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit890a012

Browse files
committed
Reorder postgresql.conf WAL section to be clearer.
1 parent5651a16 commit890a012

File tree

1 file changed

+28
-24
lines changed

1 file changed

+28
-24
lines changed

‎src/backend/utils/misc/postgresql.conf.sample

Lines changed: 28 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -44,31 +44,34 @@
4444
#
4545
#Shared Memory Size
4646
#
47-
#shared_buffers = 64# 2*max_connections, min 16
48-
#max_fsm_relations = 100# min 10, fsm is free space map
49-
#max_fsm_pages = 10000# min 1000, fsm is free space map
50-
#max_locks_per_transaction = 64# min 10
51-
#wal_buffers = 8# min 4
47+
#shared_buffers = 64# 2*max_connections, min 16
48+
#max_fsm_relations = 100# min 10, fsm is free space map
49+
#max_fsm_pages = 10000# min 1000, fsm is free space map
50+
#max_locks_per_transaction = 64# min 10
51+
#wal_buffers = 8# min 4
5252

5353
#
5454
#Non-shared Memory Sizes
5555
#
56-
#sort_mem = 512# min 32
57-
#vacuum_mem = 8192# min 1024
56+
#sort_mem = 512# min 32
57+
#vacuum_mem = 8192# min 1024
5858

5959

6060
#
6161
#Write-ahead log (WAL)
6262
#
63-
#wal_files =0 # range 0-64
64-
#wal_sync_method =fsync # the default varies across platforms:
65-
# # fsync, fdatasync, open_sync, or open_datasync
66-
#wal_debug = 0# range 0-16
67-
#commit_delay = 0 # range 0-100000
68-
#commit_siblings =5# range1-1000
69-
#checkpoint_segments =3 # in logfile segments (16MB each), min 1
70-
#checkpoint_timeout = 300 # in seconds, range 30-3600
63+
#checkpoint_segments =3# in logfile segments (16MB each), min 1
64+
#checkpoint_timeout =300# in seconds, range 30-3600
65+
#
66+
#wal_files = 0# range 0-64
67+
#
68+
#commit_delay =0# range0-100000
69+
#commit_siblings =5# range 1-1000
70+
#
7171
#fsync = true
72+
#wal_sync_method = fsync# the default varies across platforms:
73+
## fsync, fdatasync, open_sync, or open_datasync
74+
#wal_debug = 0# range 0-16
7275

7376

7477
#
@@ -84,7 +87,7 @@
8487

8588
#ksqo = false
8689

87-
#effective_cache_size = 1000# default in 8k pages
90+
#effective_cache_size = 1000# default in 8k pages
8891
#random_page_cost = 4
8992
#cpu_tuple_cost = 0.01
9093
#cpu_index_tuple_cost = 0.001
@@ -95,12 +98,13 @@
9598
#GEQO Optimizer Parameters
9699
#
97100
#geqo = true
98-
#geqo_selection_bias = 2.0# range 1.5-2.0
101+
#geqo_selection_bias = 2.0# range 1.5-2.0
99102
#geqo_threshold = 11
100-
#geqo_pool_size = 0 # default based on #tables in query, range 128-1024
103+
#geqo_pool_size = 0# default based on tables in query,
104+
# range 128-1024
101105
#geqo_effort = 1
102106
#geqo_generations = 0
103-
#geqo_random_seed = -1# auto-compute seed
107+
#geqo_random_seed = -1# auto-compute seed
104108

105109

106110
#
@@ -112,7 +116,7 @@
112116
#log_timestamp = false
113117
#log_pid = false
114118

115-
#debug_level = 0# range 0-16
119+
#debug_level = 0# range 0-16
116120

117121
#debug_print_query = false
118122
#debug_print_parse = false
@@ -128,7 +132,7 @@
128132
#Syslog
129133
#
130134
# requires ENABLE_SYSLOG
131-
#syslog = 0# range 0-2
135+
#syslog = 0# range 0-2
132136
#syslog_facility = 'LOCAL0'
133137
#syslog_ident = 'postgres'
134138

@@ -174,11 +178,11 @@
174178
#
175179
#dynamic_library_path = '$libdir'
176180
#australian_timezones = false
177-
#authentication_timeout = 60# min 1, max 600
181+
#authentication_timeout = 60# min 1, max 600
178182
#deadlock_timeout = 1000
179183
#default_transaction_isolation = 'read committed'
180-
#max_expr_depth = 10000# min 10
181-
#max_files_per_process = 1000# min 25
184+
#max_expr_depth = 10000# min 10
185+
#max_files_per_process = 1000# min 25
182186
#password_encryption = false
183187
#sql_inheritance = true
184188
#transform_null_equals = false

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp