Re: pg15b2: large objects lost on upgrade

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: pg15b2: large objects lost on upgrade
Дата
Msg-id
3445777.1659622577@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
pg15b2: large objects lost on upgrade Justin Pryzby <pryzby@telsasoft.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Justin Pryzby <pryzby@telsasoft.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Justin Pryzby <pryzby@telsasoft.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Justin Pryzby <pryzby@telsasoft.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Justin Pryzby <pryzby@telsasoft.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Bruce Momjian <bruce@momjian.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Justin Pryzby <pryzby@telsasoft.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Justin Pryzby <pryzby@telsasoft.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Bruce Momjian <bruce@momjian.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Michael Paquier <michael@paquier.xyz>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Andres Freund <andres@anarazel.de>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Bruce Momjian <bruce@momjian.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Noah Misch <noah@leadboat.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Andres Freund <andres@anarazel.de>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Andres Freund <andres@anarazel.de>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Andres Freund <andres@anarazel.de>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade "Jonathan S. Katz" <jkatz@postgresql.org>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Peter Geoghegan <pg@bowt.ie>
Re: pg15b2: large objects lost on upgrade Bruce Momjian <bruce@momjian.us>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Bruce Momjian <bruce@momjian.us>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Robert Haas <robertmhaas@gmail.com>
Re: pg15b2: large objects lost on upgrade Tom Lane <tgl@sss.pgh.pa.us>
Re: pg15b2: large objects lost on upgrade Andrew Dunstan <andrew@dunslane.net>
Re: pg15b2: large objects lost on upgrade Bruce Momjian <bruce@momjian.us>
Re: pg15b2: large objects lost on upgrade Michael Paquier <michael@paquier.xyz>
Re: pg15b2: large objects lost on upgrade Shruthi Gowda <gowdashru@gmail.com>
Re: pg15b2: large objects lost on upgrade Julien Rouhaud <rjuju123@gmail.com>
Re: pg15b2: large objects lost on upgrade Michael Paquier <michael@paquier.xyz>
"Jonathan S. Katz"  writes:
> On 8/3/22 4:19 PM, Tom Lane wrote:
>> I like the idea of txid_current(), but we have no comparable
>> function for mxid do we?  While you could get both numbers from
>> pg_control_checkpoint(), I doubt that's sufficiently up-to-date.

> ...unless we force a checkpoint in the test?

Hmm ... maybe if you take a snapshot and hold that open while
forcing the checkpoint and doing the subsequent checks.  That
seems messy though.  Also, while that should serve to hold back
global xmin, I'm not at all clear on whether that has a similar
effect on minmxid.

			regards, tom lane


В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Noah Misch
Дата:
FAQ