Re: Replication identifiers, take 4

Поиск
Список
Период
Сортировка
Искать
От
Petr Jelinek
Тема
Re: Replication identifiers, take 4
Дата
Msg-id
5517302C.6080007@2ndquadrant.com
Ответ на
Список
Дерево обсуждения
Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Peter Eisentraut <peter_e@gmx.net>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Michael Paquier <michael.paquier@gmail.com>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 4 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnaka@iki.fi>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
fix xlogdump percentage display (was Re: Replication identifiers, take 4) Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnaka@iki.fi>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Simon Riggs <simon@2ndQuadrant.com>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Peter Eisentraut <peter_e@gmx.net>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Peter Eisentraut <peter_e@gmx.net>
Re: Replication identifiers, take 4 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 4 David Rowley <dgrowleyml@gmail.com>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Simon Riggs <simon.riggs@2ndquadrant.com>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnaka@iki.fi>
Re: Replication identifiers, take 4 Simon Riggs <simon.riggs@2ndquadrant.com>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnaka@iki.fi>
Re: Replication identifiers, take 4 Simon Riggs <simon.riggs@2ndquadrant.com>
Re: Replication identifiers, take 4 Petr Jelinek <petr@2ndquadrant.com>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnaka@iki.fi>
Re: Replication identifiers, take 4 Andres Freund <andres@anarazel.de>
Re: Replication identifiers, take 4 Heikki Linnakangas <hlinnaka@iki.fi>
Re: Replication identifiers, take 3 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 3 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Replication identifiers, take 3 Simon Riggs <simon@2ndQuadrant.com>
Re: Replication identifiers, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 3 Steve Singer <steve@ssinger.info>
Re: Replication identifiers, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 3 Steve Singer <steve@ssinger.info>
Re: Replication identifiers, take 3 Andres Freund <andres@2ndquadrant.com>
Re: Replication identifiers, take 3 Robert Haas <robertmhaas@gmail.com>
Re: Replication identifiers, take 3 Petr Jelinek <petr@2ndquadrant.com>
So I did some more in depth look, I do have couple of comments.

I would really like to have something like "Logical Replication 
Infrastructure" doc section that would have both decoding and 
identifiers (and possibly even CommitTs) underneath.

There is typo in docs:
> +     
> +       The optional filter_by_origin_cb callback
> +       is called to determine wheter data that has been replayed

wheter -> whether


And finally I have issue with how the new identifiers are allocated. 
Currently, if you create identifier 'foo', remove identifier 'foo' and 
create identifier 'bar', the identifier 'bar' will have same id as the 
old 'foo' identifier. This can be problem because the identifier id is 
used as origin of the data and the replication solution using the 
replication identifiers can end up thinking that data came from node 
'bar' even though they came from the node 'foo' which no longer exists. 
This can have bad effects for example on conflict detection or debugging 
problems with replication.

Maybe another reason to use standard Oids?

--  Petr Jelinek                  http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Jeff Janes
Дата:
FAQ