>>>>> 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?

[…]

-- 
FSF associate member #7257

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to