Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] bgwriter_lru_multiplier blurbs inconsistent

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-docs(at)postgresql(dot)org, Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] bgwriter_lru_multiplier blurbs inconsistent
Date: 2008-01-20 22:05:22
Message-ID: 13942.1200866722@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> There is nothing incorrect here, it's just not as clear as it could be. 
> Here's a V2 that tries to clear that up:

> Unless limited by <varname>bgwriter_lru_maxpages</>, the number of dirty 
> buffers written in each round is based on the number of new buffers that 
> have been needed by server processes during recent rounds.  The recent 
> need is multiplied by <varname>bgwriter_lru_multiplier</> to arrive at the 
> estimate of the number of buffers that will be needed during the next 
> round.  Buffers are written to meet that need if there aren't enough 
> reusable ones found while scanning.

I think the main problem is the qualifying clause up front in a place
of prominence.  Here's a V3 try:

The number of dirty buffers written in each round is based on the number
of new buffers that have been needed by server processes during recent
rounds.  The average recent need is multiplied by
<varname>bgwriter_lru_multiplier</> to arrive at the estimate of the
number of buffers that will be needed during the next round.  Dirty
buffers are written until there are that many clean, reusable buffers
available.  However, no more than <varname>bgwriter_lru_maxpages</>
buffers will be written per round.

			regards, tom lane

In response to

Responses

pgsql-docs by date

Next:From: Greg SmithDate: 2008-01-21 03:07:52
Subject: Re: [HACKERS] bgwriter_lru_multiplier blurbs inconsistent
Previous:From: Greg SmithDate: 2008-01-20 20:55:54
Subject: Re: [HACKERS] bgwriter_lru_multiplier blurbs inconsistent

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-01-20 22:07:29
Subject: Re: Minor bug in src/port/rint.c
Previous:From: Magnus HaganderDate: 2008-01-20 22:00:33
Subject: Re: Minor bug in src/port/rint.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group