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

Re: What gets cached?

From: Alex Turner <armtuk(at)gmail(dot)com>
To: Martin Nickel <martin(at)portant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What gets cached?
Date: 2005-10-21 15:19:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Oracle uses LRU caching algorithm also, not LFU.


On 10/21/05, Martin Nickel <martin(at)portant(dot)com> wrote:
> I was reading a comment in another posting and it started me thinking
> about this. Let's say I startup an Oracle server. All my queries are a
> little bit (sometimes a lot bit) slow until it gets its "normal" things in
> memory, then it's up to speed. The "normal" things would include some
> small lookup tables and the indexes for the most frequently used tables.
> 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".
> Does this seem true?
> s
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?

In response to

pgsql-performance by date

Next:From: Jon BrisbinDate: 2005-10-21 15:29:35
Subject: Re: Used Memory
Previous:From: Steinar H. GundersonDate: 2005-10-21 12:40:38
Subject: Re: What gets cached?

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