Simon Riggs <[EMAIL PROTECTED]> writes: > On Thu, 2004-11-04 at 19:34, Tom Lane wrote: >> But only for Postgres' own shared buffers. The kernel cache still gets >> trashed, because we have no way to suggest to the kernel that it not >> hang onto the data read in.
> I guess a difference in viewpoints. I'm inclined to give most of the RAM > to PostgreSQL, since as you point out, the kernel is out of our control. > That way, we can do what we like with it - keep it or not, as we choose. That's always been a Bad Idea for three or four different reasons, of which ARC will eliminate no more than one. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings