Re: Automatic adjustment of bgwriter_lru_maxpages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Automatic adjustment of bgwriter_lru_maxpages
Date: 2007-05-14 13:52:30
Message-ID: 9814.1179150750@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-performance

Greg Smith <gsmith(at)gregsmith(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-05-14 13:53:38 Re: What is happening on buildfarm member baiji?
Previous Message Tom Lane 2007-05-14 13:49:47 Re: What is happening on buildfarm member baiji?

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Smith 2007-05-14 13:57:28 Re: Automatic adjustment of bgwriter_lru_maxpages
Previous Message Greg Smith 2007-05-14 13:46:56 Re: [PATCHES] OS/X startup scripts

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2007-05-14 13:57:28 Re: Automatic adjustment of bgwriter_lru_maxpages
Previous Message Heikki Linnakangas 2007-05-14 13:41:25 Re: Automatic adjustment of bgwriter_lru_maxpages