Re: Add pg_walinspect function with block info columns

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Add pg_walinspect function with block info columns
Дата
Msg-id ZAbPUedT4uURiHTO@paquier.xyz
обсуждение исходный текст
Ответ на Re: Add pg_walinspect function with block info columns  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Ответы Re: Add pg_walinspect function with block info columns  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
On Tue, Mar 07, 2023 at 11:17:45AM +0900, Kyotaro Horiguchi wrote:
> Thus I'm inclined to agree with Michael's suggestion of creating a new
> normalized set-returning function that returns information of
> "blocks".

Just to be clear here, I am not suggesting to add a new function for
only the block information, just a rename of the existing
pg_get_wal_fpi_info() to something like pg_get_wal_block_info() that
includes both the FPI (if any or NULL if none) and the block data (if
any or NULL is none) so as all of them are governed by the same lookup
at pg_wal/.  The fpi information (aka compression type) is displayed
if there is a FPI in the block.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: NumericShort vs NumericLong format
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Combine pg_walinspect till_end_of_wal functions with others