Re: wholly / partially table read into shared buffer

On Thu, 2007-09-20 at 19:07 +0400, Григорий Титов wrote:

> I am newbie in Postgres, but previously worked with Oracle. Now I am
> puzzled with heap_blks_hit/heap_blks_read ratio. I make select from
> table (whose size is larger than shared_buffer) and saw that it was
> wholly read from disk after second, third and so on runs. Isn't is
> wrong that RDBMS tries to cache table data blocks at least PARTIALLY
> in the case of insufficient cache buffer?

It does cache partially, but its always the wrong part of the table.

BTQ, Oracle does that too...

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com