wholly / partially table read into shared buffer - Mailing list pgsql-admin

From Григорий Титов
Subject wholly / partially table read into shared buffer
Date
Msg-id 42071190300869@webmail27.yandex.ru
Whole thread Raw
Responses Re: wholly / partially table read into shared buffer  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
Hello!
I am newbie in Postgres, but previously worked with Oracle. Now I am puzzled with heap_blks_hit/heap_blks_read ratio. I
makeselect from table (whose size is larger than shared_buffer) and saw that it was wholly read from disk after second,
thirdand so on runs. Isn't is wrong that RDBMS tries to cache table data blocks at least PARTIALLY in the case of
insufficientcache buffer? 
WBW&R, Grigory Titov.

pgsql-admin by date:

Previous
From: CaT
Date:
Subject: Re: pgpool question?
Next
From: Josef Springer
Date:
Subject: How to update from 8.1 to 8.2 ?