On 7/27/15, Paolo Bolzoni <paolo.bolzoni.brown at gmail.com> wrote: > Dear list, > > I have a somewhat large sqlite3 db (about 120GB) and I need to create > some indexes on it, but I get "database or disk is full" while I have > still about 300GB of free disk space. > > However the /tmp directory is only 5GB so I suspect that sqlite3 has > not enough space there. I found the temp_store_directory, but it is > deprecated. So I was wondering, what is the suggested alternative?
Set the TEMP environment variable to the location of your temporary storage area. > Why it is deprecated? The temp_store_directory pragma is not threadsafe and can cause incorrect results if it is changed in the middle of a query. -- D. Richard Hipp drh at sqlite.org
