- Consider `PRAGMA journal_size_limit` during ingest to avoid WAL bloat if checkpoints stall. - `cache_size = -8_000_000` (~7.6 GiB) is aggressive; good for i4i.2xlarge, but consider making it configurable via CLI (and log effective value).