Martin Kersten wrote: > For large table loads (relative to the swap size) it is advisable to > load in multiple steps. > First load the data into the tables without (foreign) key checks. > After this step ALTER the tables to respect the (foreign) keys.
Sadly the 49GB table will also not insert without foreign keys. Stefan ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers