On multi-core systems, MonetDB&#39;s mitosis optimizer ensures a good degree of intra-query parallelism. By default, the number of cores and the largest table involved determine the structure of the parallel execution, at least in the circa 2012 releases. (Yanchen Liu and I wrote a paper in 2014 discussing other strategies that can be used in selecting the table whose processing originates the aforementioned parallelism.) <br><br>Parallelism of the type described does not exist in PostgreSQL. <div>See the following for a recent discussion:<div><a href="http://www.pgcon.org/2014/schedule/events/693.en.html">http://www.pgcon.org/2014/schedule/events/693.en.html</a></div><div><br></div><div>(There may be multiple ways to build clusters with MonetDB as described in papers published on the topic.)<br><br>On Thursday, April 23, 2015, Luciano Sasso &lt;<a href="mailto:luciano@gsgroup.com.br">luciano@gsgroup.com.br</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  

    
  
  <div bgcolor="#FFFFFF" text="#000099">
    Hi,<br>
    <br>
    1- On a single server, the query is executed in parallel?, Common
    relational database also has this ability (SQL Server, PostgreSQL
    etc.)?<br>
    <br>
    2- And in a cluster, the same query is distributed for cluster nodes
    , in MonetDB?<br>
    <br>
    Att,<br>
    <br>
    <br>
    <div>-- <br>
      <table border="0" cellpadding="0" cellspacing="0" width="100%">
        <tbody>
          <tr>
            <td rowspan="4" width="233"> <img src="cid:part1.06080102.05020206@gsgroup.com.br" alt="" height="289" width="233"></td>
            <td colspan="2"> <img src="cid:part2.08080302.09090705@gsgroup.com.br" alt="" height="22" width="528"></td>
          </tr>
          <tr>
            <td colspan="2" height="96" valign="top"> <font color="black" face="Tahoma" size="5"> Luciano Sasso
                Vieira </font><br>
              <font color="gray" face="Tahoma" size="3"> Data Scientist
                &amp; Solutions Architect </font><br>
              <br>
              <font color="gray" face="Tahoma" size="2"><a href="http://www.gsgroup.com.br" style="text-decoration:none" target="_blank"><font color="gray" face="Tahoma" size="2"> luciano@gsgroup.com.br </font></a>  |  

                tel: 17 3353-0833   |   cel: 17 99706-9335 </font> </td>
          </tr>
          <tr>
            <td bgcolor="#f2f2f2"> <img src="cid:part4.08070901.03040001@gsgroup.com.br" alt="" height="58" width="250"></td>
            <td align="right" bgcolor="#f2f2f2" height="58" valign="middle" width="278"> <a href="http://www.gsgroup.com.br" style="text-decoration:none" target="_blank"><font color="gray" face="Tahoma" size="2">www.gsgroup.com.br</font></a>   

            </td>
          </tr>
          <tr>
            <td colspan="2"> <img src="cid:part6.04020808.07070107@gsgroup.com.br" alt="" height="113" width="528"></td>
          </tr>
        </tbody>
      </table>
    </div>
  
<br><br>
<hr style="border:none;color:#909090;background-color:#b0b0b0;min-height:1px;width:99%">
<table style="border-collapse:collapse;border:none">
	<tbody><tr>
		<td style="border:none;padding:0px 15px 0px 8px">
			<a href="http://www.avast.com/" target="_blank">
				<img border="0" src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo">
			</a>
		</td>
		<td>
			<p style="color:#3d4d5a;font-family:&quot;Calibri&quot;,&quot;Verdana&quot;,&quot;Arial&quot;,&quot;Helvetica&quot;;font-size:12pt">
				Este email foi escaneado pelo Avast antivírus.
				<br><a href="http://www.avast.com/" target="_blank">www.avast.com</a>
			</p>
		</td>
	</tr>
</tbody></table>
<br>
</div>

</blockquote></div></div>