Re: [ADMIN] wholly / partially table read into shared buffer

2007-09-28 Thread michal . zaborowski
On 24 Wrz, 23:59, [EMAIL PROTECTED] (Simon Riggs) wrote: > 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 s

Re: [ADMIN] wholly / partially table read into shared buffer

2007-09-24 Thread Simon Riggs
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

[ADMIN] wholly / partially table read into shared buffer

2007-09-20 Thread Григорий Титов
Hello! 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