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