On Apr 29, 2011, at 10:25 AM, James Mansion <james@xxxxxxxxxxxxxxxxxxxxxx> wrote: > 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 PG to 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? No. It models this in the optimizer, but the executor has no clue. And sometimes we model I/O as partly random, partly sequential, as in the case of heap fetches on a clustered index. So the answer isn't even a Boolean. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
