diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-04-19 00:37:28 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-04-19 00:37:28 +0000 |
| commit | 3df163ad8985c2fbf706b44a1504ffaa5da16ffa (patch) | |
| tree | 48f8ede9749d8e9c1f4451ab0a6afcaf2549636f | |
| parent | bd8d4417757b1f3edd9ef36897cf47fe96b6e37a (diff) | |
| download | postgresql-3df163ad8985c2fbf706b44a1504ffaa5da16ffa.tar.gz postgresql-3df163ad8985c2fbf706b44a1504ffaa5da16ffa.zip | |
Add more documentation about shared memory costs.
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index f32aa3ff4cb..6c5ca36e20b 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -47,12 +47,15 @@ # # Shared Memory Size # -#shared_buffers = 64 # min max_connections*2 or 16, 8KB each -#max_locks_per_transaction = 64 # min 10 -#wal_buffers = 8 # min 4, typically 8KB each +#shared_buffers = 64 # min 16, at least max_connections*2, 8KB each +#max_locks_per_transaction = 64 # min 10, ~260*max_connections bytes each +#wal_buffers = 8 # min 4, 8KB each # fsm = free space map #max_fsm_relations = 1000 # min 100, ~50 bytes each #max_fsm_pages = 20000 # min max_fsm_relations*16, 6 bytes each +# note: increasing max_connections also costs about 500 bytes each, +# in addition to costs from shared_buffers and max_locks_per_transaction. + # # Non-shared Memory Sizes |