[EMAIL PROTECTED] (Grant Succeeded) writes: > The best for me by far, is to get the OS to *not* cache stuff. As > long as the database uses the information it inherently has available, > it can make far more effective use of the same amount of memory the OS > would have used to cache the whole filesystem.
This is a very long-running debate in this community, and I think at this point the majority opinion contradicts yours. The OS buffer cache has a number of fundamental advantages over what the database can do, the most obvious being that it actually knows how much free memory is available for buffer cache at any instant. Also, the existing DBs that take the we'll-do-the-buffer-management approach are designed around thirty-year-old OS technology. I'm not inclined to accept this position without some substantial evidence in its favor. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]