From e0c9301c87634f21c0a7c6305bdc6da15d6ba375 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 27 Jun 2001 23:31:40 +0000 Subject: 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. --- src/backend/utils/misc/postgresql.conf.sample | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') 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 @@ -44,11 +44,19 @@ #krb_server_keyfile = '' +# +# 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 -- cgit v1.2.1