Re: Configuring for maximum memory usage

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Scott Carey <scott(at)richrelevance(dot)com>, Christiaan Willemsen <cwillemsen(at)technocon(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Configuring for maximum memory usage
Date: 2008-10-30 17:00:23
Message-ID: 20081030170023.GH3857@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2008-10-30 17:26:26 Re: Configuring for maximum memory usage
Previous Message Christiaan Willemsen 2008-10-30 16:56:16 Re: Configuring for maximum memory usage