On Tue, Aug 05, 2008 at 05:25:09PM +0200, Cronje Fourie wrote:
Hi guys....
I've got to machines running Monet.
- Quad core Intel with 4GB RAM, Ubuntu 8.04 32BIT (server ed)
- AMD64 Quad Core, 4GB RAM, KUbuntu 8.04 64BIT (kde 3.5.9)
On system 1 I can do a "copy into" of 6million records in no time at all :)
On system 2 the same function, with the exact same data takes forever.
Any thoughts on the reason? Is this a memory related issue?
I assume that you configure MonetDB on both machines with the same (if any) optimization and/or debugging options and compiled it with the same (versions of) tools (in particular compiler).
Morover, I assume that you built a 64-bit version with 64-bit OIDs on the 64-bit machine (should be the default on a 64-bit machines).
Finally, I assume that both machines have comparable I/O systems (disks).
Did/can you check how big your mserver5 process is growing on both machines during the copy into, and/or whether either machines (obviously the second one) is swapping heavily during the copy into?
How wide are your records, i.e., what does your 'create table' statement look like?
Do you load from a plain (uncompressed) file or from a compressed (how) file?
Stefan
Cronje