On multi-core systems, MonetDB'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.)
Parallelism of the type described does not exist in PostgreSQL. See the following for a recent discussion: http://www.pgcon.org/2014/schedule/events/693.en.html
(There may be multiple ways to build clusters with MonetDB as described in papers published on the topic.)
On Thursday, April 23, 2015, Luciano Sasso luciano@gsgroup.com.br wrote:
Hi,
1- On a single server, the query is executed in parallel?, Common relational database also has this ability (SQL Server, PostgreSQL etc.)?
2- And in a cluster, the same query is distributed for cluster nodes , in MonetDB?
Att,
-- 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
[image: Avast logo] http://www.avast.com/
Este email foi escaneado pelo Avast antivírus. www.avast.com
