Re: Automatic adjustment of bgwriter_lru_maxpages

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Automatic adjustment of bgwriter_lru_maxpages
Дата
Msg-id Pine.GSO.4.64.0705140926470.9478@westnet.com
обсуждение исходный текст
Ответ на Re: Automatic adjustment of bgwriter_lru_maxpages  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Ответы Re: Automatic adjustment of bgwriter_lru_maxpages  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: Automatic adjustment of bgwriter_lru_maxpages  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Mon, 14 May 2007, ITAGAKI Takahiro wrote:

> BTW, your patch will cut LRU writes short, but will not encourage to
> do more works. So should set more aggressive values to bgwriter_lru_percent
> and bgwriter_lru_maxpages as defaults?

Setting a bigger default maximum is one possibility I was thinking about.
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".

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

В списке pgsql-patches по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: [DOCS] OS/X startup scripts
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Automatic adjustment of bgwriter_lru_maxpages