wholly / partially table read into shared buffer

Поиск
Список
Период
Сортировка
От Григорий Титов
Тема wholly / partially table read into shared buffer
Дата
Msg-id 42071190300869@webmail27.yandex.ru
обсуждение исходный текст
Ответы Re: wholly / partially table read into shared buffer  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: CaT
Дата:
Сообщение: Re: pgpool question?
Следующее
От: Josef Springer
Дата:
Сообщение: How to update from 8.1 to 8.2 ?