diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-06-27 23:31:40 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-06-27 23:31:40 +0000 |
| commit | e0c9301c87634f21c0a7c6305bdc6da15d6ba375 (patch) | |
| tree | aad976ca0197137c3461ff19a3d0e155487f7b44 /src/backend/utils/misc/postgresql.conf.sample | |
| parent | b559382134a52bbe1d79d465afd89c8385f88581 (diff) | |
| download | postgresql-e0c9301c87634f21c0a7c6305bdc6da15d6ba375.tar.gz | |
Install infrastructure for shared-memory free space map. Doesn't actually
do anything yet, but it has the necessary connections to initialization
and so forth. Make some gestures towards allowing number of blocks in
a relation to be BlockNumber, ie, unsigned int, rather than signed int.
(I doubt I got all the places that are sloppy about it, yet.) On the
way, replace the hardwired NLOCKS_PER_XACT fudge factor with a GUC
variable.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index a77666d9f4..a3042bee83 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -45,10 +45,18 @@ # +# Shared Memory Size +# +#shared_buffers = 64 # 2*max_connections, min 16 +#max_fsm_relations = 100 # min 10 +#max_fsm_pages = 10000 # min 1000 +#max_locks_per_xact = 64 # min 10 +#wal_buffers = 8 # min 4 + +# # Performance # #sort_mem = 512 -#shared_buffers = 64 # 2*max_connections, min 16 #fsync = true @@ -78,7 +86,7 @@ # GEQO Optimizer Parameters # #geqo_threshold = 11 -#geqo_pool_size = 0 #default based in tables, 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 @@ -87,7 +95,6 @@ # # Write-ahead log (WAL) # -#wal_buffers = 8 # min 4 #wal_files = 0 # range 0-64 #wal_sync_method = fsync # fsync or fdatasync or open_sync or open_datasync # Note: default wal_sync_method varies across platforms |