SQLite Forum

intterupted vacuum
Dear SQLiters

Before vacuuming a 100GB database, I failed to realize that as much as twice free space is needed. I prepared a factor 150GB. Vacuum failed with "disk full" error. I created more free disk space and wanted to resume vacuum. Both times (first and after the error) I wanted to allow SQLite to use 3G of RAM to speed up using PRAGMA cache_size = -3000000. It was using 3GB (actually 6GB, as it should) during the first (failed) attempt. But as soon as I executed

PRAGMA cache_size = -3000000;

it seems to have resumed vacuuming, but without using RAM. This means it will be very slow. Is there a way to get it to use RAM? (I am using version 3.33)

Thank you,