Isn't journal_size_limit is exactly for this? From the doc: "Each time a transac... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		kissgyorgy on June 15, 2024 \| parent \| context \| favorite \| on: Django SQLite Production Config 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."

kgeist on June 15, 2024 | [–]

If there's checkpoint starvation, the WAL file cannot be reset, and it will still grow indefinitely even with this setting.

anze3db on June 15, 2024 | [–]

From 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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact