On Sat, Nov 3, 2012 at 8:56 AM, Ivan Shmakov <oneing...@gmail.com> wrote:
> >>>>> Richard Hipp writes: > >>>>> On Fri, Nov 2, 2012 at 6:44 PM, Tod Olson wrote: > > […] > > >> This is fine on small data, but when I load 1.8GB of data (8.8 > >> million rows) the second CREATE fails, reporting a disk I/O error. > > > You might be running out of /tmp space. Do you have plenty of /tmp > > space available for use by the sorter. > > Do I understand it correctly that SQLite actually uses $TMPDIR, > and defaults to /tmp if it's not set or empty? > First, it uses whatever directory you set with "PRAGMA temp_store_directory". (But read about the fact that this PRAGMA is deprecated and is not threadsafe before using it!) If that is not set, then it consults $TMPDIR If neither of those is set, it searches for /var/tmp, /usr/tmp, and then /tmp. If none of those are available, it uses ".". > > […] > > -- > FSF associate member #7257 > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
