Re: Checksum errors in pg_stat_database

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Checksum errors in pg_stat_database
Дата
Msg-id 20221212005149.yrw7qrjq2u5guuf3@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Checksum errors in pg_stat_database  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Checksum errors in pg_stat_database  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Hi,

On 2022-12-12 08:40:04 +0900, Michael Paquier wrote:
> What about just adding a counter tracking the number of checksum
> failures for relfilenodes in a new structure related to them (note
> that I did not write PgStat_StatTabEntry)?

Why were you thinking of tracking it separately from PgStat_StatTabEntry?

I think there's a good argument for starting to track some stats based on the
relfilenode, rather the oid, because it'd allow us to track e.g. the number of
writes for a relation too (we don't have the oid when writing out
buffers). But that's a relatively large change...

Greetings,

Andres Freund



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: GetNewObjectId question
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Checksum errors in pg_stat_database