Re: Logical Replication WIP

Поиск
Список
Период
Сортировка
Искать
От
Craig Ringer
Тема
Re: Logical Replication WIP
Дата
Msg-id
CAMsr+YE09BCHCibU0GLR4eT1CXmUKWxpUmOvZmodhw8L5mU4UQ@mail.gmail.com
Ответ на
Re: Logical Replication WIP (Masahiko Sawada)
Список
Дерево обсуждения
Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Simon Riggs <simon@2ndquadrant.com>
Re: Logical Replication WIP Masahiko Sawada <sawada.mshk@gmail.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Craig Ringer <craig@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Logical Replication WIP Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Tom Lane <tgl@sss.pgh.pa.us>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Craig Ringer <craig@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Craig Ringer <craig@2ndquadrant.com>
Re: Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Michael Paquier <michael.paquier@gmail.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Robert Haas <robertmhaas@gmail.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Euler Taveira <euler@timbira.com.br>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP - FailedAssertion, File:"array_typanalyze.c", Line: 340 Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP - FailedAssertion, File:"array_typanalyze.c", Line: 340 Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP - FailedAssertion, File:"array_typanalyze.c", Line: 340 Erik Rijkers <er@xs4all.nl>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Thom Brown <thom@linux.com>
Re: [HACKERS] Logical Replication WIP Fujii Masao <masao.fujii@gmail.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Jaime Casanova <jaime.casanova@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Logical Replication WIP Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Logical Replication WIP Fujii Masao <masao.fujii@gmail.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Jaime Casanova <jaime.casanova@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: Logical Replication WIP Thomas Munro <thomas.munro@enterprisedb.com>
Re: Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: Logical Replication WIP Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: [HACKERS] Logical Replication WIP Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: Logical Replication WIP Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Andres Freund <andres@anarazel.de>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: Logical Replication WIP Erik Rijkers <er@xs4all.nl>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Michael Paquier <michael.paquier@gmail.com>
Re: Logical Replication WIP Masahiko Sawada <sawada.mshk@gmail.com>
Re: Logical Replication WIP Craig Ringer <craig@2ndquadrant.com>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
Re: Logical Replication WIP Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Logical Replication WIP Steve Singer <steve@ssinger.info>
Re: Logical Replication WIP Petr Jelinek <petr@2ndquadrant.com>
On 9 August 2016 at 17:28, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
 
> Sure, you can go deeper down the rabbit hole here and say that we need to
> add bgworker "categories" with reserved pools of worker slots for each
> category. But do we really need that?

If we change these processes to bgworker, we can categorize them into
two, auxiliary process(check pointer and  wal sender etc) and other
worker process.
And max_worker_processes controls the latter.

Right. I think that's probably the direction we should be going eventually. Personally I don't think such a change should block the logical replication work from proceeding with bgworkers, though. It's been delayed a long time, a lot of people want it, and I think we need to focus on meeting the core requirements not getting too sidetracked on minor points.

Of course, everyone's idea of what's core and what's a minor sidetrack differs ;) 


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления
От: Masahiko Sawada
Дата:
Сообщение: Re: Logical Replication WIP
От: Petr Jelinek
Дата:
Сообщение: Re: Logical Replication WIP
FAQ