Re: Configuring for maximum memory usage - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Configuring for maximum memory usage
Date
Msg-id 20081030170023.GH3857@alvh.no-ip.org
Whole thread Raw
In response to Re: Configuring for maximum memory usage  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Configuring for maximum memory usage  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Christiaan Willemsen
Date:
Subject: Re: Configuring for maximum memory usage
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Configuring for maximum memory usage