Re: Performance

Robert Haas wrote:
> The server can and does measure hit rates for the PG buffer pool, but to my knowledge there is no clear-cut way for
PGto know whether read() is satisfied from the OS cache or a drive cache or the platter. 
>
>
Does the server know which IO it thinks is sequential, and which it
thinks is random?  Could it not time the IOs (perhaps optionally) and at
least keep some sort of statistics of the actual observed times?

It might not be appropriate for the server to attempt auto-tuning, but
it might be able to provide some information that can be used by a DBA
to make informed decisions.

James