Re: [PATCH] add relation and block-level filtering to pg_waldump

Поиск
Список
Период
Сортировка
От Japin Li
Тема Re: [PATCH] add relation and block-level filtering to pg_waldump
Дата
Msg-id MEYP282MB1669791B8B59D6CF2C785BDAB63E9@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на [PATCH] add relation and block-level filtering to pg_waldump  (David Christensen <david.christensen@crunchydata.com>)
Ответы Re: [PATCH] add relation and block-level filtering to pg_waldump  (David Christensen <david.christensen@crunchydata.com>)
Список pgsql-hackers
On Fri, 25 Feb 2022 at 03:02, David Christensen <david.christensen@crunchydata.com> wrote:
> Greetings,
>
> This patch adds the ability to specify a RelFileNode and optional BlockNum to limit output of
> pg_waldump records to only those which match the given criteria.  This should be more performant
> than `pg_waldump | grep` as well as more reliable given specific variations in output style
> depending on how the blocks are specified.
>
> This currently affects only the main fork, but we could presumably add the option to filter by fork
> as well, if that is considered useful.
>

Cool.  I think we can report an error instead of reading wal files,
if the tablespace, database, or relation is invalid.  Does there any
WAL record that has invalid tablespace, database, or relation OID?

-- 
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.



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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Add checkpoint and redo LSN to LogCheckpointEnd log message
Следующее
От: Yugo NAGATA
Дата:
Сообщение: Re: Typo in pgbench messages.