Re: Add statistics to pg_stat_wal view for wal related parameter tuning - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Add statistics to pg_stat_wal view for wal related parameter tuning
Date
Msg-id 20201221211650.k7b53tcnadrciqjo@alap3.anarazel.de
Whole thread Raw
In response to Re: Add statistics to pg_stat_wal view for wal related parameter tuning  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Responses Re: Add statistics to pg_stat_wal view for wal related parameter tuning
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: zstd compression for pg_dump
Next
From: Robert Haas
Date:
Subject: Re: Incorrect allocation handling for cryptohash functions with OpenSSL