Re: Configuring for maximum memory usage

Joshua D. Drake wrote:

> However that isn't the exact same thing as a "cache" at least as I was
> trying to describe it. shared buffers are used to keep track of pages
> (as well as some other stuff) and their current status. That is not the
> same as caching a relation.

Um, having a page in shared buffers means exactly that the page is
cached (a.k.a. it won't have to be read from the lower level next time).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.