Re: wholly / partially table read into shared buffer

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: wholly / partially table read into shared buffer
Дата
Msg-id 1190671185.4181.236.camel@ebony.site
обсуждение исходный текст
Ответ на wholly / partially table read into shared buffer  (Григорий Титов <nav73@narod.ru>)
Ответы Re: wholly / partially table read into shared buffer  (michal.zaborowski@gmail.com)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Jessica Richard
Дата:
Сообщение: Re: hanging Postgres connections....
Следующее
От: "Cesar Otero"
Дата:
Сообщение: Restarting standby database have to reaply WAL (redo logs)