On 17-7-2014 21:11, Roger Binns wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 17/07/14 10:42, veeresh kumar wrote:
When i execute the command PRAGMA temp_store, it returned me 0. What is
the ideal value that needs to be set?
A quick google search would have found the answer:
https://sqlite.org/pragma.html#pragma_temp_store
so, 0 means temp is written to disk.
Back to the the question.....
How much free disk space is there?
I think you need more than 14Gb of free space if your database is 14Gb
in size.
http://lmgtfy.com/?q=sqlite+vacuum+how+much+disk+space+is+needed&l=1
"This means that when VACUUMing a database, as much as twice the size of
the original database file is required in free disk space. "
(source: http://sqlite.org/lang_vacuum.html)
So, you will need 28Gb of free disk space......
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users