PgFincore 0.4.1

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : BSD - BSD License
CreatedCreated : May 5, 2010
Size downloadDownloads : 4
Program licensing
Thank you for voting...

Each database table or index is truncated in several ...

Each database table or index is truncated in several parts of around 1GB, and each segment is truncated itself in filesystem blocks.
These functions let the developer 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.
Using this file, it is possible to restore the page cache state for each block of the relation.
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 block 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.
• PostgreSQL
News in the current PgFincore by C├ędric Villemain version:
• Use AllocateFile instead of fopen.
• Call PG_GETARG* earlier.
• Remove useless global counter.
• Added error handler in pgfadv_snapshot().
• errno to catch the last segment.
• Improve Readme.
• Some minor fix and beautify.

PgFincore 0.4.1 scripting tags: segment, functions, page, block, memory usage, pgfincore, memory block, disk segment, cache, relation. What is new in PgFincore 0.4.1 software script? - Unable to find PgFincore 0.4.1 news. What is improvements are expecting? Newly-made PgFincore 0.5 will be downloaded from here. You may download directly. Please write the reviews of the PgFincore. License limitations are unspecified.