A set of functions to manage blocks in 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 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 package
-
Checkout Package
osc -A https://api.opensuse.org checkout server:database:postgresql/postgresql-pgfincore && cd $_ - Create Badge
Source Files
| Filename | Size | Changed |
|---|---|---|
| _multibuild | 0000000231 231 Bytes | |
| _service | 0000000544 544 Bytes | |
| _servicedata | 0000000242 242 Bytes | |
| pgfincore-1.3.1.tar.xz | 0000015732 15.4 KB | |
| postgresql-pgfincore.changes | 0000003782 3.69 KB | |
| postgresql-pgfincore.spec | 0000002505 2.45 KB |
Latest Revision
Marcus Rueckert (darix)
committed
(revision 19)
- enable pg 16 - Update to version 1.3.1: * OK, go for 1.3.1 with missing commits for 1.3 * Prepare for 1.3 * Update GHA with comments and add missing files for 1.3 * Update Changelog * Just some reordering of code * Update GHA for node12 EOL * Add support for PostgreSQL 16 * Drop support for < PG 9.3 * Debian: Upload for PostgreSQL 15.
Comments 0