From 5d5087363d7cdbd00fc432a1216e83a00f7139bd Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 4 Mar 2005 20:21:07 +0000 Subject: Replace the BufMgrLock with separate locks on the lookup hashtable and the freelist, plus per-buffer spinlocks that protect access to individual shared buffer headers. This requires abandoning a global freelist (since the freelist is a global contention point), which shoots down ARC and 2Q as well as plain LRU management. Adopt a clock sweep algorithm instead. Preliminary results show substantial improvement in multi-backend situations. --- src/backend/utils/misc/postgresql.conf.sample | 6 ++++-- 1 file changed, 4 insertions(+), 2 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 86640efa7d..74a029e657 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -99,8 +99,10 @@ # - Background writer - #bgwriter_delay = 200 # 10-10000 milliseconds between rounds -#bgwriter_percent = 1 # 0-100% of dirty buffers in each round -#bgwriter_maxpages = 100 # 0-1000 buffers max per round +#bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned in each round +#bgwriter_lru_maxpages = 5 # 0-1000 buffers max written per round +#bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned in each round +#bgwriter_all_maxpages = 5 # 0-1000 buffers max written per round #--------------------------------------------------------------------------- -- cgit v1.2.1