Re: Parallell Optimizer - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Parallell Optimizer
Date
Msg-id 20130611.094528.83183479329987568.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Parallell Optimizer  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Parallell Optimizer
Re: Parallell Optimizer
List pgsql-hackers
> On Sat, Jun 8, 2013 at 5:04 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> 
>> On 7 June 2013 20:23, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>
>> > As for other databases, I suspect that ones that have parallel execution
>> > are probably doing it with a thread model not a process model.
>>
>> Separate processes are more common because it covers the general case
>> where query execution is spread across multiple nodes. Threads don't
>> work across nodes and parallel queries predate (working) threading
>> models.
>>
> Indeed. Parallelism based on processes would be more convenient for
> master-master
> type of applications. Even if no master-master feature is implemented
> directly in core,
>  at least a parallelism infrastructure based on processes could be used for
> this purpose.

As long as "true" synchronous replication is not implemented in core,
I am not sure there's a value for parallel execution spreading across
multile nodes because of the delay of data update propagation.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Parallell Optimizer
Next
From: Michael Paquier
Date:
Subject: Re: Parallell Optimizer