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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
