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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
