Durability & caching

Durable by default — acknowledged means fsynced. Two caches sit in front of disk; both are explicit.

Durability modes

--durability durable (default) fsyncs every WAL batch with group-commit; batched fsyncs on --batch-interval; async leaves it to the OS (bulk-load only).

Loss window · durable ≤ 1 ms · batched ≤ --batch-interval · async unbounded.

Block & record caches

--cache-size sizes the block cache (S3-FIFO). The optional record cache (--record-cache-size) holds whole records you pin with INCACHE.

INCACHE "creditos" WHERE status = "active"
OUTCACHE "creditos"

Pinning ghost fields

Ghosts project only the fields a query needs. PIN forces a field into every projection (persisted across restarts).

PIN amount, status IN "creditos"