Re: Performance

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Performance
Дата
Msg-id D2F0DB51-7D42-4573-99CA-B72E28440B16@gmail.com
обсуждение исходный текст
Ответ на Re: Performance  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: Performance  (Claudio Freire <klaussfreire@gmail.com>)
Re: Performance  (James Mansion <james@mansionfamily.plus.com>)
Список pgsql-performance
On Apr 14, 2011, at 2:49 AM, Claudio Freire <klaussfreire@gmail.com> wrote:
> This particular factor is not about an abstract and opaque "Workload"
> the server can't know about. It's about cache hit rate, and the server
> can indeed measure that.

The server can and does measure hit rates for the PG buffer pool, but to my knowledge there is no clear-cut way for PG
toknow whether read() is satisfied from the OS cache or a drive cache or the platter. 

...Robert

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

Предыдущее
От: Rob Wultsch
Дата:
Сообщение: Re: Time to put theory to the test?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Performance