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.
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.
On 20/02/16 19:39, Luciano Sasso wrote:
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.
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
Hi,
this is indeed unexpected.
To possibly better understand what's happening, could you please run your query prefixed with keyword TRACE and share the trace (profiling) result?
Best, Stefan
----- On Feb 20, 2016, at 7:39 PM, Luciano Sasso luciano@gsgroup.com.br wrote:
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.
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
luciano@gsgroup.com.br | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br
Este e-mail foi enviado por um computador sem vírus e protegido pelo Avast. www.avast.com
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Luciano Sasso
-
Martin Kersten
-
Stefan Manegold