Re: Use WALReadFromBuffers in more places - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Use WALReadFromBuffers in more places
Date
Msg-id 783426a05a756b29b5b1ef4d5640f22d999fdec8.camel@j-davis.com
Whole thread Raw
In response to Re: Use WALReadFromBuffers in more places  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: Use WALReadFromBuffers in more places
List pgsql-hackers
On Wed, 2025-09-24 at 07:26 -0700, Bharath Rupireddy wrote:
> Right. Reading unflushed WAL buffers for replication was one of the
> motivations. But, in general, WALReadFromBuffers has more benefits
> since it lets WAL buffers act as a cache for reads, avoiding the need
> to re-read WAL from disk for (both physical and logical) replication.
> For example, it makes the use of direct I/O for WAL more realistic
> and
> can provide significant performance benefits [1].

Is it possible to do a POC that shows the potential benefit, or are we
still too far away?

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Invalid primary_slot_name triggers warnings in all processes on reload
Next
From: Masahiko Sawada
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication