Greg Smith <gsmith(at)gregsmith(dot)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?
NTT Open Source Software Center
In response to
pgsql-hackers by date
|Next:||From: Jeremy Drake||Date: 2007-06-28 06:16:21|
|Subject: Re: Bugtraq: Having Fun With PostgreSQL|
|Previous:||From: Josh Berkus||Date: 2007-06-28 01:38:58|
|Subject: Re: What does Page Layout version mean? (Was: Re: Reducing NUMERIC size for 8.3)|