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 http://www.gsgroup.com.br | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br http://www.gsgroup.com.br --- Este email foi escaneado pelo Avast antivírus. https://www.avast.com/antivirus
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
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
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (3)
-
Luciano Sasso -
Martin Kersten -
Stefan Manegold