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

Commit350db87

Browse files
committed
Remove very-obsolete estimates of shmem usage from postgresql.conf.sample.
runtime.sgml used to contain a table of estimated shared memory consumptionrates for max_connections and some other GUCs. Commit390bfc6 removedthat on the well-founded grounds that (a) we weren't maintaining theentries well and (b) it no longer mattered so much once we got out fromunder SysV shmem limits. But it missed that there were even-more-obsoleteversions of some of those numbers in comments in postgresql.conf.sample.Remove those too. Back-patch to 9.3 where the aforesaid commit went in.
1 parent0aabe80 commit350db87

File tree

1 file changed

+2
-9
lines changed

1 file changed

+2
-9
lines changed

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

Lines changed: 2 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -62,8 +62,6 @@
6262
# (change requires restart)
6363
#port = 5432# (change requires restart)
6464
#max_connections = 100# (change requires restart)
65-
# Note: Increasing max_connections costs ~400 bytes of shared memory per
66-
# connection slot, plus lock space (see max_locks_per_transaction).
6765
#superuser_reserved_connections = 3# (change requires restart)
6866
#unix_socket_directories = '/tmp'# comma-separated list of directories
6967
# (change requires restart)
@@ -119,10 +117,8 @@
119117
#temp_buffers = 8MB# min 800kB
120118
#max_prepared_transactions = 0# zero disables the feature
121119
# (change requires restart)
122-
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory
123-
# per transaction slot, plus lock space (see max_locks_per_transaction).
124-
# It is not advisable to set max_prepared_transactions nonzero unless you
125-
# actively intend to use prepared transactions.
120+
# Caution: it is not advisable to set max_prepared_transactions nonzero unless
121+
# you actively intend to use prepared transactions.
126122
#work_mem = 4MB# min 64kB
127123
#maintenance_work_mem = 64MB# min 1MB
128124
#autovacuum_work_mem = -1# min 1MB, or -1 to use maintenance_work_mem
@@ -573,9 +569,6 @@
573569
#deadlock_timeout = 1s
574570
#max_locks_per_transaction = 64# min 10
575571
# (change requires restart)
576-
# Note: Each lock table slot uses ~270 bytes of shared memory, and there are
577-
# max_locks_per_transaction * (max_connections + max_prepared_transactions)
578-
# lock table slots.
579572
#max_pred_locks_per_transaction = 64# min 10
580573
# (change requires restart)
581574

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp