Re: Replication identifiers, take 4
От
Petr Jelinek
Тема
Re: Replication identifiers, take 4
Дата
Msg-id
5517302C.6080007@2ndquadrant.com
Ответ на
Re: Replication identifiers, take 4 (Petr Jelinek)
Список
Дерево обсуждения
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 по дате отправления