Re: Logical Replication WIP
От
Alvaro Herrera
Тема
Re: Logical Replication WIP
Дата
Msg-id
20160809203102.GA582807@alvherre.pgsql
Ответ на
Re: Logical Replication WIP (Petr Jelinek)
Список
Дерево обсуждения
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
Дата: