Re: Show WAL write and fsync stats in pg_stat_io - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Show WAL write and fsync stats in pg_stat_io
Date
Msg-id 991876.1738807584@sss.pgh.pa.us
Whole thread Raw
In response to Re: Show WAL write and fsync stats in pg_stat_io  (Nazir Bilal Yavuz <byavuz81@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: wenhui qiu
Date:
Subject: Re: Trigger more frequent autovacuums of heavy insert tables
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.