| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, "bharath(dot)rupireddyforpostgres(at)gmail(dot)com" <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Subject: | Re: Show WAL write and fsync stats in pg_stat_io |
| Date: | 2025-02-06 02:06:24 |
| Message-ID: | 991876.1738807584@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> writes:
> On Wed, 5 Feb 2025 at 21:32, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hayato Kuroda (Fujitsu) | 2025-02-06 02:07:16 | RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. |
| Previous Message | wenhui qiu | 2025-02-06 01:54:07 | Re: Trigger more frequent autovacuums of heavy insert tables |