http://villemain.org/ 2010-05-25T04:01:25+02:00 http://villemain.org/ http://villemain.org/lib/images/favicon.ico text/html 2010-05-23T07:15:10+02:00 Cédric Villemain http://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:43:01+02:00 Cédric Villemain http://villemain.org/topbar?rev=1272670981&do=diff * Projects * PostgreSQL Stuff * PgFincore * Active * Dead or Quiet * Snippnets * FreeWifi text/html 2010-05-01T01:39:12+02:00 Cédric Villemain http://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) text/html 2010-05-01T00:51:22+02:00 Cédric Villemain http://villemain.org/start?rev=1272667882&do=diff Projects Active * my stuff @ PostgreSQL * I play with blocks disk thanks to PgFincore. Try it :) * Nagios Check_Postgres is just great. * I also enjoy PNP4Nagios to get beautifull graph from Nagios. * I like those Slony1-ctl administration scripts.