Re: Show WAL write and fsync stats in pg_stat_io

Nazir Bilal Yavuz <byavuz81@gmail.com> writes:
> On Wed, 5 Feb 2025 at 21:32, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Locally, the test added by this commit fails like so:

> My thoughts when adding this test was that startup process must do the
> WAL read I/O while server is starting, i.e.:

Oh!  The problem is much simpler than I thought, then, and not
particularly related to configure options.  I was misled by
not trying repeated tests, but:

$ ./configure ...
$ make; make install
$ initdb ...; pg_ctl start
$ make installcheck
... all OK ...
$ make installcheck
... fails ...
$ make installcheck
... fails ...
$ make installcheck
... fails ...
$ make installcheck
... fails ...

Basically, this test is broken because it assumes that the server
is freshly started.  That's not a scenario the buildfarm runs
the core tests under, unfortunately, but it is one commonly
used in hand testing.

            regards, tom lane