Re: Recommended Initial Settings

Campbell, Lance wrote:
> Richard,
> Thanks for your reply.
>
> You said:
> "Your operating-system should be doing the caching for you."
>
> My understanding is that as long as Linux has memory available it will
> cache files.  Then from your comment I get the impression that since
> Linux would be caching the data files for the postgres database it would
> be redundant to have a large shared_buffers.  Did I understand you
> correctly?

That's right - PG works with the O.S. This means it *might* not be a big
advantage to have a large shared_buffers.

On older versions of PG, the buffer management code wasn't great with
large shared_buffers values too.

--
   Richard Huxton
   Archonet Ltd