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.