Re: [MonetDB-users] select distinct ... where algorithm

select count(distinct uuid) from f_sorted where yyyymm='201110'; +---------+ | L6 | +=========+ | 5941581 | +---------+ 1 tuple (23.8s)

Very fast thus far! However:

copy (select distinct(uuid) from f_sorted where yyyymm='201110') into '/home/user/filename' USING DELIMITERS ',','\n','"' NULL as 'null';

This has been running for hours and has yet to start writing to the file. Indeed, it should finish quickly. This indicates that there other issues involved in your environment, e.g. competition of other resource hungry

processors. Or, the (dbfarm) disk on which you want to write is (almost) full.