Re: The shared buffers challenge - Mailing list pgsql-performance

From Claudio Freire
Subject Re: The shared buffers challenge
Date
Msg-id BANLkTik=POOCsOzh-LQg0FhWC6Pa-MNfOQ@mail.gmail.com
Whole thread Raw
In response to Re: The shared buffers challenge  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: The shared buffers challenge
List pgsql-performance
On Thu, May 26, 2011 at 5:36 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
> Point being: cranking buffers
> may have been the bee's knees with, say, the 8.2 buffer manager, but
> present and future improvements may have render that change moot or
> even counter productive.

I suggest you read the docs on how shared buffers work, because,
reasonably, it would be all the way around.

Recent improvments into how postgres manage its shared buffer pool
makes them better than the OS cache, so there should be more incentive
to increase them, rather than decrease them.

Workload conditions may make those improvements worthless, hinting
that you should decrease them.

But you have to know your workload and you have to know how the shared
buffers work.

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: The shared buffers challenge
Next
From: Merlin Moncure
Date:
Subject: Re: The shared buffers challenge