3 ms·
Isn't journal_size_limit is exactly for this? From the doc: "Each time a transaction is committed or a WAL file resets, SQLite compares the size of the rollbac
by kissgyorgy 2y ago
Isn't journal_size_limit is exactly for this?
From the doc:
"Each time a transaction is committed or a WAL file resets, SQLite compares the size of the rollback journal file or WAL file left in the file-system to the size limit set by this pragma and if the journal or WAL file is larger it is truncated to the limit."
- anze3db 2y agoFrom what I understand, you still need the experimental WAL2 mode[0] to not have this problem. [0] https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md
- kgeist 2y agoIf there's checkpoint starvation, the WAL file cannot be reset, and it will still grow indefinitely even with this setting.