Re: Parallell Optimizer
От
Tatsuo Ishii
Тема
Re: Parallell Optimizer
Дата
Msg-id
20130611.235357.1532922951140265651.t-ishii@sraoss.co.jp
Ответ на
Re: Parallell Optimizer (Simon Riggs)
Список
Дерево обсуждения
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 по дате отправления