Hi,

Thank you for your reply.

The system has 16 physical cores (2 sockets, 8 cores/sockets, 20MB L3 cache, 256KB L2) and 64GB of RAM. The MonetDB server uses 16 threads to serve my test database and it finds ~63GB of available memory.

I used synthetic data to populate the two tables (with names A and B). The particular query I reported about in my previous e-mail generates a lot of output: approx. 500 million tuples. The join predicate is (A.a1 < B.b1) where columns A.a1 and B.b1 contain all unique integers from 1 to 32768.

With a lower selectivity (say, 1%, by controlling the values inserted into A.a1 and B.b1), the query executes faster but its behaviour is the same: only 1 thread is utilised.

Attached is a trace of the query.

Hope this helps,

Alexandros

PS: Apologies for the separate thread; somehow I ended up subscribing in digest mode

Hi

This is insufficient information to shed light on it.
Crucial information is system characteristics.
And also a TRACE of your query can shed light on the issue.

Furthermore, is it a cold or hot execution of the query?

regards, Martin

On 20/01/16 13:24, Alexandros Koliousis wrote:
> Hi,
>
> I am joining two tables, each with 32K tuples. The query runs for ~23-24 seconds on my (multi-core) machine.
>
> During execution, however, only 1 core is utilised, while the rest of the CPU cores are idle. The cores are under-utilised although I have configured the MonetDB server to use all the physical cores of my machine (either by setting 'nthreads' or, in the
> case of mserver5, 'gdk_nr_threads').
>
> I am running MonetDB server v11.21.13 "Jul2015-SP2", compiled from source.
>
> Is this due to some configuration setting I missed? Or, due to the fact that I am running a single-operator query?
>
> Alternatively, I was thinking of creating merge tables, thus partitioning my tables manually, hoping that this will allow for intra-operator parallelism.
>
> Thanks,
>
> Alexandros
>
>
>
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>