Re: Add statistics to pg_stat_wal view for wal related parameter tuning

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Add statistics to pg_stat_wal view for wal related parameter tuning
Дата
Msg-id 20201221211650.k7b53tcnadrciqjo@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Add statistics to pg_stat_wal view for wal related parameter tuning  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Ответы Re: Add statistics to pg_stat_wal view for wal related parameter tuning  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi,

On 2020-12-02 13:52:43 +0900, Fujii Masao wrote:
> Pushed. Thanks!

Why are wal_records/fpi long, instead of uint64?
    long        wal_records;    /* # of WAL records produced */
    long        wal_fpi;        /* # of WAL full page images produced */
    uint64        wal_bytes;        /* size of WAL records produced */

long is only 4 byte e.g. on windows, and it is entirely possible to wrap
a 4 byte record counter. It's also somewhat weird that wal_bytes is
unsigned, but the others are signed?

This is made doubly weird because on the SQL level you chose to make
wal_records, wal_fpi bigint. And wal_bytes numeric?

Greetings,

Andres Freund



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: zstd compression for pg_dump
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Incorrect allocation handling for cryptohash functions with OpenSSL