diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-03-04 20:21:07 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-03-04 20:21:07 +0000 |
| commit | 5d5087363d7cdbd00fc432a1216e83a00f7139bd (patch) | |
| tree | 56492be3beb9be188f37bfa68c9bfc0e35b0961c /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 5592a6cf46d60187b6f4895d2144e67d4f54fa25 (diff) | |
| download | postgresql-5d5087363d7cdbd00fc432a1216e83a00f7139bd.tar.gz postgresql-5d5087363d7cdbd00fc432a1216e83a00f7139bd.zip | |
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.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 86640efa7da..74a029e6574 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 #--------------------------------------------------------------------------- |