Re: Show WAL write and fsync stats in pg_stat_io

From: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: 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-04 14:40:06
Message-ID: CAN55FZ384dMjCrg0au=y5h54zaDFM=N+zBA61qRnG0P87hLm5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Tue, 4 Feb 2025 at 17:29, Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> wrote:
>
> Thanks! My benchmark results are the same [1]. I could not see the
> noticable difference between master and patched version. I run the
> benchmark a couple of times, sometimes the patched version, sometimes the
> master version is better. I think the differences are due to margin of
> error. Sharing the latest benchmark run at the bottom [1].
>
> [1]
> pgbench -n -c8 -j8-T60 -f <(echo "SELECT pg_logical_emit_message(true, 'test', repeat('0', ${emit_bytes}));";)
> with emit bytes being 10 and 8192 for the 'acpi_pm', 'hpet' and 'tsc' clock sources.
>
> (I hope that table gets rendered correctly in the mailing list.)

It did not get rendered correctly, so attached as a text file.

--
Regards,
Nazir Bilal Yavuz
Microsoft

Attachment Content-Type Size
benchmark_results application/octet-stream 11.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2025-02-04 14:56:20 Re: Convert sepgsql tests to TAP
Previous Message Nazir Bilal Yavuz 2025-02-04 14:29:55 Re: Show WAL write and fsync stats in pg_stat_io