PgFincore 1.1 is out!

New version of PgFincore is out!

Dowload the 1.1 here:
http://pgfoundry.org/frs/download.php/3117/pgfincore-v1.1.tar.gz
Homepage: http://villemain.org/projects/pgfincore

Thanks to everybody who helped review and improve this new version.

__________________________

A set of functions to handle low-level management of relations using mincore to
explore cache memory.

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 node, 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.
__________________________

Major Changes:

* partial support for systems without POSIX_FADVISE ( *BSD and others)
* suport for PostgreSQL 8.3
* debian packaging (now included in debian/sid)

Details:

- Fix Makefile and remove the dir sql/ (useless and error prone)
- Fix the printf of int64 by casting to long long int (i386 and adm64
behave differently with int64)
- Updated to work with PostgreSQL 8.3 (TAKATSUKA Haruka)
- Improve debian packaging (Dimitri Fontaine)
- Add support for *BSD kernels
- Remove mention of PGXS in the README

--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation