| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> |
| Cc: | "bharath(dot)rupireddyforpostgres(at)gmail(dot)com" <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Show WAL write and fsync stats in pg_stat_io |
| Date: | 2023-11-07 03:25:27 |
| Message-ID: | ZUmuJ7P8THHz03nx@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Nov 06, 2023 at 03:35:01PM +0300, Nazir Bilal Yavuz wrote:
> Results are:
>
> ╔═════════╦═══════════════════════════════╦════════╗
> ║ ║ track_wal_io_timing ║ ║
> ╠═════════╬═══════════════╦═══════════════╬════════╣
> ║ clock ║ on ║ off ║ change ║
> ║ sources ║ ║ ║ ║
> ╠═════════╬═══════════════╬═══════════════╬════════╣
> ║ tsc ║ ║ ║ ║
> ║ ║ 514814.459170 ║ 519826.284139 ║ %1 ║
> ╠═════════╬═══════════════╬═══════════════╬════════╣
> ║ hpet ║ ║ ║ ║
> ║ ║ 132116.272121 ║ 141820.548447 ║ %7 ║
> ╠═════════╬═══════════════╬═══════════════╬════════╣
> ║ acpi_pm ║ ║ ║ ║
> ║ ║ 394793.092255 ║ 403723.874719 ║ %2 ║
> ╚═════════╩═══════════════╩═══════════════╩════════╝
Thanks for the tests. That's indeed noticeable under this load.
Better to keep track_io_timing and track_wal_io_timing as two
separated beasts, at least that's clear.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nathan Bossart | 2023-11-07 03:35:58 | Re: Atomic ops for unlogged LSN |
| Previous Message | Noah Misch | 2023-11-07 03:15:01 | Re: Popcount optimization using AVX512 |