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) |