perf(storage): run PRAGMA optimize periodically

[xsmyile]

No periodic PRAGMA optimize runs, so query-planner statistics are never refreshed on long-lived databases. Run it on the writer at startup/shutdown and after large retention sweeps.