Re: [HACKERS] [PATCH] pageinspect function to decode infomasks

Поиск
Список
Период
Сортировка
Искать
От
Tomas Vondra
Тема
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks
Дата
Msg-id
a4adf3a3-7bab-f25d-2ddd-9d72cb548367@2ndquadrant.com
Ответ на
Список
Дерево обсуждения
[HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Julien Rouhaud <rjuju123@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks "Moon Insung" <Moon_Insung_i3@lab.ntt.co.jp>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks "Moon Insung" <Moon_Insung_i3@lab.ntt.co.jp>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Vik Fearing <vik.fearing@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Alvaro Herrera from 2ndQuadrant <alvherre@alvh.no-ip.org>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Alvaro Herrera from 2ndQuadrant <alvherre@alvh.no-ip.org>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] [PATCH] pageinspect function to decode infomasks Craig Ringer <craig@2ndquadrant.com>


On 08/15/2017 03:24 PM, Robert Haas wrote:
> On Mon, Aug 14, 2017 at 9:59 PM, Craig Ringer  wrote:
>> The bits are set, those macros just test to exclude the special meaning of
>> both bits being set at once to mean "frozen".
>>
>> I was reluctant to filter out  HEAP_XMIN_COMMITTED and HEAP_XMIN_INVALID
>> when we detect that it's frozen, because that could well be misleading when
>> debugging.
> 
> I don't think so -- the "committed" and "invalid" meanings are
> effectively canceled when the "frozen" mask is present.
> 
> I mean, "committed" and "invalid" contradict each other...
> 

FWIW I agree with Craig - the functions should output the masks raw, 
without any filtering. The reason is that when you're investigating data 
corruption or unexpected behavior, all this is very useful when 
reasoning about what might (not) have happened.

Or at least make the filtering optional.

regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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