[Monetdb-developers] Another big group by query

Stefan de Konink stefan at konink.de
Sun Apr 12 03:15:36 CEST 2009


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




More information about the developers-list mailing list