Re: Parallell Optimizer

Поиск
Список
Период
Сортировка
Искать
От
Tatsuo Ishii
Тема
Re: Parallell Optimizer
Дата
Msg-id
20130611.235357.1532922951140265651.t-ishii@sraoss.co.jp
Ответ на
Список
Дерево обсуждения
Parallell Optimizer "Fred&Dani&Pandora&Aquiles" <fred@nti.ufop.br>
Re: Parallell Optimizer Tom Lane <tgl@sss.pgh.pa.us>
Re: Parallell Optimizer Robert Haas <robertmhaas@gmail.com>
Re: Parallell Optimizer Tom Lane <tgl@sss.pgh.pa.us>
Re: Parallell Optimizer Jim Nasby <jim@nasby.net>
Re: Parallell Optimizer Robert Haas <robertmhaas@gmail.com>
Re: Parallell Optimizer Simon Riggs <simon@2ndQuadrant.com>
Re: Parallell Optimizer Michael Paquier <michael.paquier@gmail.com>
Re: Parallell Optimizer Tatsuo Ishii <ishii@postgresql.org>
Re: Parallell Optimizer Simon Riggs <simon@2ndQuadrant.com>
Re: Parallell Optimizer Tatsuo Ishii <ishii@postgresql.org>
Re: Parallell Optimizer Hannu Krosing <hannu@2ndQuadrant.com>
Re: Parallell Optimizer Tatsuo Ishii <ishii@postgresql.org>
Re: Parallell Optimizer Hannu Krosing <hannu@2ndQuadrant.com>
Re: Parallell Optimizer Tatsuo Ishii <ishii@postgresql.org>
Re: Parallell Optimizer Craig Ringer <craig@2ndquadrant.com>
Re: Parallell Optimizer Ants Aasma <ants@cybertec.at>
Re: Parallell Optimizer Tatsuo Ishii <ishii@postgresql.org>
Re: Parallell Optimizer Hannu Krosing <hannu@2ndQuadrant.com>
Re: Parallell Optimizer Ants Aasma <ants@cybertec.at>
Re: Parallell Optimizer Ants Aasma <ants@cybertec.at>
Re: Parallell Optimizer Tatsuo Ishii <ishii@postgresql.org>
Re: Parallell Optimizer Stephen Frost <sfrost@snowman.net>
Re: Parallell Optimizer Ants Aasma <ants.aasma@eesti.ee>
Re: Parallell Optimizer Stephen Frost <sfrost@snowman.net>
Re: Parallell Optimizer Simon Riggs <simon@2ndQuadrant.com>
Re: Parallell Optimizer Ants Aasma <ants@cybertec.at>
Re: Parallell Optimizer Michael Paquier <michael.paquier@gmail.com>
Re: Parallell Optimizer Tatsuo Ishii <ishii@postgresql.org>
Re: Parallell Optimizer Simon Riggs <simon@2ndQuadrant.com>
Re: Parallell Optimizer "Fred&Dani&Pandora&Aquiles" <fred@nti.ufop.br>
Re: Parallell Optimizer Hannu Krosing <hannu@2ndQuadrant.com>
Re: Parallell Optimizer Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Parallell Optimizer Yeb Havinga <yebhavinga@gmail.com>
> On 11 June 2013 01:45, Tatsuo Ishii  wrote:
>>> On Sat, Jun 8, 2013 at 5:04 AM, Simon Riggs  wrote:
>>>
>>>> On 7 June 2013 20:23, Tom Lane  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.
> 
> Please explain what you mean by the word "true" used here.

In another word, "eager replication".
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


В списке pgsql-hackers по дате отправления
От: Stephen Frost
Дата:
Сообщение: Re: DO ... RETURNING
От: Tatsuo Ishii
Дата:
Сообщение: Re: Parallell Optimizer
FAQ