Re: Improve description of XLOG_RUNNING_XACTS

Поиск
Список
Период
Сортировка
Искать
От
Kyotaro Horiguchi
Тема
Re: Improve description of XLOG_RUNNING_XACTS
Дата
Msg-id
20220721.172840.842755856795467411.horikyota.ntt@gmail.com
Ответ на
Список
Дерево обсуждения
Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Amit Kapila <amit.kapila16@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Amit Kapila <amit.kapila16@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Michael Paquier <michael@paquier.xyz>
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Amit Kapila <amit.kapila16@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Amit Kapila <amit.kapila16@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Michael Paquier <michael@paquier.xyz>
Re: Improve description of XLOG_RUNNING_XACTS Michael Paquier <michael@paquier.xyz>
Re: Improve description of XLOG_RUNNING_XACTS Amit Kapila <amit.kapila16@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Amit Kapila <amit.kapila16@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Ian Lawrence Barwick <barwick@gmail.com>
Inconsistencies in error messages Ekaterina Kiryanova <e.kiryanova@postgrespro.ru>
Re: Inconsistencies in error messages John Naylor <john.naylor@enterprisedb.com>
Re: Inconsistencies in error messages Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Inconsistencies in error messages John Naylor <john.naylor@enterprisedb.com>
Re: Improve description of XLOG_RUNNING_XACTS Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Masahiko Sawada <sawada.mshk@gmail.com>
Re: Improve description of XLOG_RUNNING_XACTS Kyotaro Horiguchi <horikyota.ntt@gmail.com>
At Thu, 21 Jul 2022 16:58:45 +0900, Masahiko Sawada  wrote in 
> > > The patch looks good to me.

By the way +1 to this.

> > The subxids can reach TOTAL_MAX_CACHED_SUBXIDS =
> > PGPROC_MAX_CACHED_SUBXIDS(=64) * PROCARRAY_MAXPROCS. xact_desc_commit
> > also shows subtransactions but they are at maximum 64.  I feel like
> > -0.3 if there's no obvious advantage showing them.
> 
> xxx_desc() functions are debugging purpose functions as they are used
> by pg_waldump and pg_walinspect etc. I think such functions should
> show all contents unless there is reason to hide them. Particularly,
> standby_desc_running_xacts() currently shows subtransaction
> information only when subtransactions are overflowed, which got me
> confused when inspecting WAL records.

I'm not sure just confusing can justify that but after finding
logicalmsg_desc dumps the whole content, I no longer feel against to
show subxacts.  

Just for information, but as far as I saw, relmap_desc shows only the
length of "data" but doesn't dump all of it. generic_desc behaves the
same way.  Thus we could just show "%d subxacts" instead of dumping
out the all subxact ids just to avoid that confusion.

However, again, I no longer object to show all subxids.

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center


В списке pgsql-hackers по дате отправления
От: Junwang Zhao
Дата:
От: Amit Kapila
Дата:
FAQ