Hi All,
Might be better to go by the mailinglist instead of adding many people
to the CC. Currently I am running the latest CVS code disabled mitosis
and am running the following code:
CREATE TABLE "sys"."way_nds" (
"way" int NOT NULL,
"idx" int NOT NULL,
"to_node" int,
CONSTRAINT "pk_way_nds" PRIMARY KEY ("way", "idx")
);
select count(way), way, to_node from way_nds group by way, to_node
having count(way) > 1;
The table contains about 362420451 rows, and I realised too late there
could be many results comming from it.
top - 03:12:15 up 1 day, 17:28, 8 users, load average: 1.00, 1.00, 1.00
Tasks: 193 total, 1 running, 192 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.1%sy, 0.0%ni, 94.6%id, 5.2%wa, 0.0%hi, 0.0%si,
0.0%st
Mem: 66113464k total, 39353192k used, 26760272k free, 326968k buffers
Swap: 134215032k total, 94284k used, 134120748k free, 8489128k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11856 konink 20 0 51.5g 34g 5.9g S 0.3 54.6 45:34.93 mserver5
But again the load is low, the memory empty and it seems to do so few.
Is there something that would be interesting to look at?
Stefan
------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
