public inbox for [email protected]
help / color / mirror / Atom feedRe: Use WALReadFromBuffers in more places
2+ messages / 2 participants
[nested] [flat]
* Re: Use WALReadFromBuffers in more places
@ 2024-05-08 04:20 Jingtang Zhang <[email protected]>
2024-05-13 05:35 ` Re: Use WALReadFromBuffers in more places Bharath Rupireddy <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Jingtang Zhang @ 2024-05-08 04:20 UTC (permalink / raw)
To: Bharath Rupireddy <[email protected]>; +Cc: pgsql-hackers
Hi, Bharath. I've been testing this. It's cool. Is there any way we could
monitor the hit rate about directly reading from WAL buffers by exporting
to some views?
---
Regards, Jingtang
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Use WALReadFromBuffers in more places
2024-05-08 04:20 Re: Use WALReadFromBuffers in more places Jingtang Zhang <[email protected]>
@ 2024-05-13 05:35 ` Bharath Rupireddy <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Bharath Rupireddy @ 2024-05-13 05:35 UTC (permalink / raw)
To: Jingtang Zhang <[email protected]>; +Cc: pgsql-hackers
On Wed, May 8, 2024 at 9:51 AM Jingtang Zhang <[email protected]> wrote:
>
> Hi, Bharath. I've been testing this. It's cool. Is there any way we could
> monitor the hit rate about directly reading from WAL buffers by exporting
> to some views?
Thanks for looking into this. I used purpose-built patches for
verifying the WAL buffers hit ratio, please check
USE-ON-HEAD-Collect-WAL-read-from-file-stats.txt and
USE-ON-PATCH-Collect-WAL-read-from-buffers-and-file-stats.txt at
https://www.postgresql.org/message-id/CALj2ACU9cfAcfVsGwUqXMace_7rfSBJ7%2BhXVJfVV1jnspTDGHQ%40mail.g....
In the long run, it's better to extend what's proposed in the thread
https://www.postgresql.org/message-id/CALj2ACU_f5_c8F%2BxyNR4HURjG%3DJziiz07wCpQc%3DAqAJUFh7%2B8w%40....
I haven't had a chance to dive deep into that thread yet, but a quick
glance over v8 patch tells me that it hasn't yet implemented the idea
of collecting WAL read stats for both walsenders and the backends
reading WAL. If that's done, we can extend it for WAL read from WAL
buffers.
--
Bharath Rupireddy
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-05-13 05:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-08 04:20 Re: Use WALReadFromBuffers in more places Jingtang Zhang <[email protected]>
2024-05-13 05:35 ` Bharath Rupireddy <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox