{"repo":"klando/pgfincore","free":true,"listed":false,"github":"https://github.com/klando/pgfincore","clone":"git clone https://github.com/klando/pgfincore.git","description":"Official place for contributing to pgfincore | another remote exists at http://git.postgresql.org/gitweb/?p=pgfincore.git;a=summary","language":"C","stars":111,"topics":["postgresql-extension","postgres","postgresql","database"],"license":null,"category":"databases-storage","readme_excerpt":"PgFincore -------------------------------------------------------------- A set of functions to manage pages in memory from PostgreSQL -------------------------------------------------------------- A set of functions to handle low-level management of relations using mincore to explore cache memory. DESCRIPTION With PostgreSQL, each Table or Index is splitted in segments of (usually) 1GB, and each segment is splitted in pages in memory then in blocks for the filesystem. Those functions let you know which and how many disk block from a relation are in the page cache of the operating system. It can provide the result as a VarBit and can be stored in a table. Then using this table, it is possible to restore the page cache state for each block of the relation, even in another server, thanks to Streaming Replication. Other functions are used to set a POSIX FADVISE flag on the entire relation (each segment). The more usefull are probably WILLNEED and DONTNEED which push and pop blocks of each segments of a relation from page cache, respectively. Each functions are call with at least a table name or an index name (or oid) as a parameter and walk each segment of the relation. DOWNLOAD You can grab the latest code with git: git clone git://git.postgresql.org/git/pgfincore.git or git://github.com/klando/pgfincore.git And the project is on pgfoundry : http://pgfoundry.org/projects/pgfincore INSTALL From source code: make clean make su make install For PostgreSQL = 9.1, log in your databas","default_branch":null,"files":null,"tree":[],"storefront":"/r/klando","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/klando/pgfincore/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}