Dear Richard, As soon as I execute PRAGMA cache_size = -3000000; sqlite3 shell starts doing something (command did not return for one hour so far). I presume it resumed vacuum. Should I interrupt it and try VACUUM INTO? I do not see how this will get it to use more RAM. Roman