Re: Performance - Mailing list pgsql-performance

From Robert Haas
Subject Re: Performance
Date
Msg-id D2F0DB51-7D42-4573-99CA-B72E28440B16@gmail.com
Whole thread Raw
In response to Re: Performance  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Performance
Re: Performance
List 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 by date:

Previous
From: Rob Wultsch
Date:
Subject: Re: Time to put theory to the test?
Next
From: Robert Haas
Date:
Subject: Re: Performance