Hello Alexey, Tuesday, March 8, 2011, 11:51:22 AM, you wrote:
AP> I try to vacuum database about 11Gb size on debian squeeze host with 1,5 Gb RAM: AP> sqlite3 test.db 'vacuum;' AP> Error: disk I/O error AP> Note: any new files does not created on vacuuming process (may be AP> created journal, does not it?). AP> But this work correct: AP> sqlite3 test.db '.dump'|sqlite3 test2.db On my windows 7 box using current Sqlite, vacuuming anything over about 7 gigs seems to be hit or miss. I haven't pursued it. I just dump the DB's to SQL and re-generate them, like you do. It's far faster than vacuum. Never have below 100 gigs free when I've tested this. -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users