Re: [sqlite] Setting auto_vacuum=2 doesn't work after setting journal_mode=WAL

I do the exact same pragmas as Jens, and also in this order. I was even convinced that it was working, so I'll need to double check. The documentation might be correct if you know what to look for, but from current experience it's not obvious. Wout. On Sat., Feb. 22, 2020, 4:02 a.m. Keith Medcal

Re: [sqlite] Setting auto_vacuum=2 doesn't work after setting journal_mode=WAL

On Friday, 21 February, 2020 19:36, Simon Slavin wrote: >On 22 Feb 2020, at 2:28am, Keith Medcalf wrote: >> When a database is to be created these commands must be given BEFORE >any command which opens or creates the database: >> >> pragma auto_vacuum >> pragma encoding >> pragma page_size >>

Re: [sqlite] Setting auto_vacuum=2 doesn't work after setting journal_mode=WAL

On 22 Feb 2020, at 2:28am, Keith Medcalf wrote: > When a database is to be created these commands must be given BEFORE any > command which opens or creates the database: > > pragma auto_vacuum > pragma encoding > pragma page_size > pragma data_store_directory > > The issuance (or preparation)

Re: [sqlite] Setting auto_vacuum=2 doesn't work after setting journal_mode=WAL

r tables are created. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users On >Behalf Of Jens Alfke >Sent: Friday, 21 February, 2020 16:24 >To: SQLite mailing list

[sqlite] Setting auto_vacuum=2 doesn't work after setting journal_mode=WAL

I just discovered that none of our databases are auto-vacuuming, even though we set auto_vacuum to 'incremental' when a database is created, and periodically call 'pragma incremental_vacuum'. If I go into the CLI, open a database and run "pragma auto_vacuum", it returns 0. After some experiment