On Mon, Oct 20, 2008 at 09:20:25AM -0700, Richard Wesley wrote:
On 17 Oct 2008, at 16:48, Martin Kersten wrote:
The batch size should not be the problem. It is the final table size. Are you running on a 32bits machine?
Yes. So the final table size has to fit in memory? Even during inserts?
During inserts (even only batches) all columns of the table are accessed. As MonetDB's memory maps columns it requires the adres space needed for all the data. So if your data exceeds the 32bit address space this will fail. Niels
________________________________________________________ Richard Wesley Senior Software Developer Tableau Software Visit: http://www.trytableau.com/now.html
------------------------------------------------------------------------- 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-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl