Re: Logical Replication WIP

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Logical Replication WIP
Дата
Msg-id
20160809203102.GA582807@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
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>
Petr Jelinek wrote:
> On 09/08/16 12:16, Craig Ringer wrote:

> >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.
> 
> Yeah that's why I added local max GUC that just handles the logical worker
> limit within the max_worker_processes. I didn't want to also write generic
> framework for managing the max workers using tags or something as part of
> this, it's big enough as it is and we can always move the limit to the more
> generic place once we have it.

Parallel query does exactly that: the workers are allocated from the
bgworkers array, and if you want more, it's on you to increase that
limit (it doesn't even have the GUC for a maximum).  As far as logical
replication and parallel query are concerned, that's fine.  We can
improve this later, if it proves to be a problem.

I think there are far more pressing matters to review.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Alvaro Herrera
Дата:
Сообщение: Re: Logical Replication WIP
FAQ