Skip to content

pgvfs 0.3.1

Pre-release
Pre-release

Choose a tag to compare

@adonm adonm released this 14 Oct 15:30
· 4 commits to main since this release

pgdb:// reads ahead: a cold scan stops paying a round trip per block (2.60 s to 0.70 s for a 1.2 GB scan), with no change to point lookups.

INSTALL pgvfs FROM 'https://pgvfs.adonm.dev';   -- DuckDB 1.5.6, or a 2.0 dev build
LOAD pgvfs;

What's in 0.3.1

Storage layout: v2 (unchanged). No FFI or table changes.

  • pgdb:// reads ahead. A read that continues the previous one also
    fetches the blocks after it, so scans stop costing a round trip per block
    (2.6 s to 0.70 s for a cold 1.2 GB scan with 16 KiB blocks, 438 ms to 163 ms
    with 8 threads) and range scans nearly halve. A read after a gap fetches
    exactly its own bytes, so point lookups are unchanged. Knobs:
    PGVFS_DB_READAHEAD_KB (1 MiB) and PGVFS_DB_READAHEAD_SLOTS (8). New
    counters: db_readahead_hits, db_readahead_bytes.
  • Block size is documented as a knob (BLOCK_SIZE at creation):
    Databases.
  • Comments trimmed across the Rust and C++ sources; the house style is in
    CONTRIBUTING.md.

Docs: https://pgvfs.adonm.dev · Changelog: https://github.com/adonm/pgvfs/blob/v0.3.1/CHANGELOG.md · All builds: https://pgvfs.adonm.dev/install.html#builds