Hi, I'm working on it, please wait.. Thanks. Dariusz. Stefan Manegold wrote:
On Wed, Apr 21, 2010 at 08:23:06PM +0200, Fabian Groffen wrote:
On 21-04-2010 14:15:33 -0400, dariuszs wrote:
Single thread works, but what does it really mean? Thanks. Dariusz
It means you likely have the same problem as Hering Cheng, which seems related to parallelism.
You can try to unset (monetdb inherit nrthreads demo) the single threadedness once you have loaded the data.
Just to make sure, Dariusz' problem is not with loading data from .csv file into the database (copy into from file) but with dumping data from the database into a .csv file (copy select ... into file). Hence, is it not necessarily related to Hering Cheng's loading problem.
I just tried a (simplified) dump like
copy select * from tables limit 10 into '/tmp/output.txt';
on my 4-core Febdora 12 desktop with Feb2010, Feb2010-SP1 & Feb2010-SP2 preview, and all work fine.
Dariusz,
could you please test & report whether this simple version also works (in standard multi-threaded mode) also on your 16-core machine(s)?
Could you also check & report, wether the select part (without copy ... into file) works fine on your machine(s), i.e., select * from table1 limit 1000;
Thanks!
Stefan
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users