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? Why it is deprecated? Your faithfully, Paolo
