http://www.villemain.org/ 2010-05-31T10:08:39+02:00 http://www.villemain.org/ http://www.villemain.org/lib/images/favicon.ico text/html 2010-05-23T07:15:10+02:00 http://www.villemain.org/projects/pgfincore?rev=1274591710&do=diff A talk about PgFincore is scheduled at PgCon10. PgFincore is a set of functions to manage blocks in memory. Each Table or Index is truncated in segment of (usually) 1GB, and each segment is truncated in block in filesystem. Those functions let you know which and how many disk block from a relation are in the page cache of the operating system, and eventually write the result to a file. Then using this file, it is possible to restore the page cache state for each block of the relation. text/html 2010-05-01T01:39:12+02:00 http://www.villemain.org/projects/postgres_stuff?rev=1272670752&do=diff You can clone my branches : git clone http://git.postgresql.org/git/users/c2main/postgres.git Track Disk statistics Current fun is provided by adding a column for indexes and tables in pg_statio* views. Those column output the real read on disk: it let calculate the real hit/miss ratio of your full cache (postgresql shared buffers and OS buffer cache)