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

Commit3df163a

Browse files
committed
Add more documentation about shared memory costs.
1 parentbd8d441 commit3df163a

File tree

1 file changed

+6
-3
lines changed

1 file changed

+6
-3
lines changed

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

Lines changed: 6 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -47,12 +47,15 @@
4747
#
4848
#Shared Memory Size
4949
#
50-
#shared_buffers = 64# min max_connections*2 or 16, 8KB each
51-
#max_locks_per_transaction = 64# min 10
52-
#wal_buffers = 8# min 4,typically8KB each
50+
#shared_buffers = 64# min16, at leastmax_connections*2, 8KB each
51+
#max_locks_per_transaction = 64# min 10, ~260*max_connections bytes each
52+
#wal_buffers = 8# min 4, 8KB each
5353
# fsm = free space map
5454
#max_fsm_relations = 1000# min 100, ~50 bytes each
5555
#max_fsm_pages = 20000# min max_fsm_relations*16, 6 bytes each
56+
# note: increasing max_connections also costs about 500 bytes each,
57+
# in addition to costs from shared_buffers and max_locks_per_transaction.
58+
5659

5760
#
5861
#Non-shared Memory Sizes

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp