commit 08b011ad077260952cfcef573be25f28441b214c
parent 2b03f11e5ea62764c9de8dce24a00fc7f524aef6
Author: Greg Heartsfield <scsibug@imap.cc>
Date: Sat, 10 Sep 2022 19:18:57 -0500
feat: ensure that WAL is truncated after checkpoint
Diffstat:
1 file changed, 1 insertion(+), 0 deletions(-)
diff --git a/src/schema.rs b/src/schema.rs
@@ -13,6 +13,7 @@ use std::time::Instant;
pub const STARTUP_SQL: &str = r##"
PRAGMA main.synchronous=NORMAL;
PRAGMA foreign_keys = ON;
+PRAGMA journal_size_limit=32768;
pragma mmap_size = 536870912; -- 512MB of mmap
"##;