Hi,
I have MonetDB JUL2015-SP2, with table of 100M rows and 20 coluns, 4 of number type, others string type.
A simple "select count(*) from table", run on 90 minutes.
On 20/02/16 19:39, Luciano Sasso wrote: that is not normal. most likely there are a lot of other processes competing for resources.
Hardware and SO is: Debian 8, 4 cores, 11G RAM and 20G free on disc.
While monet run the query, command top, show 42G of virtual memory
Its normal ?, any idea ?
thanks.
--
Luciano Sasso Vieira Data Scientist & Solutions Architect
http://www.gsgroup.com.brluciano@gsgroup.com.br | tel: 17 3353-0833 | cel: 17 99706-9335 http://www.gsgroup.com.brwww.gsgroup.com.br
Este e-mail foi enviado por um computador sem vírus e protegido pelo Avast. www.avast.com https://www.avast.com/sig-email
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list