Re: Catalog/Metadata consistency during changeset extraction from wal
От
Kevin Grittner
Тема
Re: Catalog/Metadata consistency during changeset
extraction from wal
Дата
Msg-id
4FE9EBD70200002500048B40@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Amit Kapila <amit.kapila@huawei.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Robert Haas <robertmhaas@gmail.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Amit Kapila <amit.kapila@huawei.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Robert Haas <robertmhaas@gmail.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Robert Haas <robertmhaas@gmail.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Robert Haas <robertmhaas@gmail.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Catalog/Metadata consistency during changeset
extraction from wal Robert Haas <robertmhaas@gmail.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Catalog/Metadata consistency during changeset extraction from wal Alvaro Herrera <alvherre@commandprompt.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal David Fetter <david@fetter.org>
Re: Catalog/Metadata consistency during changeset
extraction from wal "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Catalog/Metadata consistency during changeset
extraction from wal David Fetter <david@fetter.org>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndQuadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndQuadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndQuadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Florian Pflug <fgp@phlo.org>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Florian Pflug <fgp@phlo.org>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndQuadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndQuadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndQuadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
Re: Catalog/Metadata consistency during changeset
extraction from wal Simon Riggs <simon@2ndQuadrant.com>
Re: Catalog/Metadata consistency during changeset extraction from wal Andres Freund <andres@2ndquadrant.com>
David Fetter wrote: > On Mon, Jun 25, 2012 at 01:50:54PM -0500, Kevin Grittner wrote: >> One fine point regarding before and after images -- if a value >> doesn't change in an UPDATE, there's no reason to include it in >> both the BEFORE and AFTER tuple images, as long as we have the >> null column bitmaps -- or some other way of distinguishing >> unchanged from NULL. (This could be especially important when >> the unchanged column was a 50 MB bytea.) > > How about two bitmaps: one telling which columns are actually > there, the other with NULLs? There are quite a few ways that could be done, but I suspect Álvaro's idea is best: http://archives.postgresql.org/message-id/1340654533-sup-5535@alvh.no-ip.org In any event, it sounds like Andres wants to keep it as simple as possible for the moment, and just include both tuples in their entirety. Hopefully that is something which can be revisited before the last CF. -Kevin
В списке pgsql-hackers по дате отправления