Re: Bgwriter LRU cleaning: we've been going at this all wrong

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: Bgwriter LRU cleaning: we've been going at this all wrong
Дата
Msg-id 20070628130743.69C5.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Bgwriter LRU cleaning: we've been going at this all wrong  (Greg Smith <gsmith@gregsmith.com>)
Ответы Re: Bgwriter LRU cleaning: we've been going at this all wrong  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-hackers
Greg Smith <gsmith@gregsmith.com> wrote:

> If your entire buffer cache is mostly filled with dirty buffers with high 
> usage counts, you are in for a long wait when you need new buffers 
> allocated and your next checkpoint is going to be traumatic.

Do you need to increase shared_buffers in such case?

I think the condition (mostly buffers have high usage counts) is
very undesirable for us and near out-of-memory. We should deal with
such cases, of course, but is it a more effective solution to make
room in shared_buffers?

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: What does Page Layout version mean? (Was: Re: Reducing NUMERIC size for 8.3)
Следующее
От: Jeremy Drake
Дата:
Сообщение: Re: Bugtraq: Having Fun With PostgreSQL