Greg Smith <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
