Re: Automatic adjustment of bgwriter_lru_maxpages - Mailing list pgsql-patches

From Tom Lane
Subject Re: Automatic adjustment of bgwriter_lru_maxpages
Date
Msg-id 9814.1179150750@sss.pgh.pa.us
Whole thread Raw
In response to Re: Automatic adjustment of bgwriter_lru_maxpages  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: Automatic adjustment of bgwriter_lru_maxpages  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-patches
Greg Smith <gsmith@gregsmith.com> writes:
> Since the whole background writer setup is kind of complicated, the other
> thing I was working on is writing a guide on how to use the new
> pg_stat_bgwriter information to figure out if you need to increase
> bgwriter_[all|lru]_pages (and the other parameters too).  It makes it much
> easier to write that if you can say "You can safely set
> bgwriter_lru_maxpages high because it only writes what it needs to based
> on your usage".

If you can write something like that, why do we need the parameter at all?

            regards, tom lane

pgsql-patches by date:

Previous
From: Greg Smith
Date:
Subject: Re: [DOCS] OS/X startup scripts
Next
From: Greg Smith
Date:
Subject: Re: Automatic adjustment of bgwriter_lru_maxpages