On Sat, Sep 30, 2017 at 11:41 PM, Clemens Ladisch <clem...@ladisch.de> wrote:
> Kevin O'Gorman wrote: > > my latest trial run ended with a segmentation fault > > Really a segmentation fault? What is the error message? > What such things always say "segementation fault (core dumped)" and the name of the program. > > > This particular program is merging two databases. The result has reached > > 25 GB, roughly 1/3 of what I expect of the final result (over 100M rows). > > The filesystem is a RAID with 2+ TB free. > > Does the /var/tmp filesystem fill up? > No. And /var/tmp is not used as I've redirected tmp onto my RAID > > > Here's my prime suspect: I'm using WAL, and the journal is 543 MB. > > In WAL mode, the log stores the new versions of all changed pages. > In rollback journal mode, the journal stores the old version of all > changed pages. So when you're creating a new DB (where the old version > is empty), journal rollback mode is likely to be more efficient. > > I'm not creating a new database. I'm merging one into the other. > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- word of the year: *kakistocracy* _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users