Skip site navigation (1) Skip section navigation (2)

Re: What gets cached?

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: What gets cached?
Date: 2005-10-21 12:40:38
Message-ID: 20051021124038.GA1928@samfundet.no (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Oct 21, 2005 at 07:34:30AM -0500, Martin Nickel wrote:
> Let's say I do the same thing in Postgres.  I'm likely to have my very
> fastest performance for the first few queries until memory gets filled up.
>  The only time Postgres seems to take advantage of cached data is when I
>  repeat the same (or substantially the same) query.  I don't know of any
>  way to view what is actually cached at any point in time, but it seems
>  like "most recently used" rather than "most frequently used". 

What version are you using? There have been significant improvements to the
buffer manager in the last few versions. Most of the caching is done by your
OS, though, so that would probably influence the results quite a bit.

/* Steinar */
-- 
Homepage: http://www.sesse.net/


In response to

pgsql-performance by date

Next:From: Alex TurnerDate: 2005-10-21 15:19:10
Subject: Re: What gets cached?
Previous:From: Martin NickelDate: 2005-10-21 12:34:30
Subject: What gets cached?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group