Hi Bharath, thank you for the suggestion.
> On 5 Aug 2022, at 16:02, Bharath Rupireddy > <[email protected]> wrote: > > On Thu, Aug 4, 2022 at 9:48 PM Andrey Borodin <[email protected]> wrote: >> >>> On 18 Jul 2022, at 22:55, Robert Haas <[email protected]> wrote: >>> >>> On Thu, Jun 23, 2022 at 5:49 AM Jakub Wartak <[email protected]> >>> wrote: > > I have a fundamental question on the overall idea - How beneficial it > will be if the process that's reading the current WAL page only does > (at least attempts) the prefetching of future WAL pages? Won't the > benefit be higher if "some" other background process does prefetching? IMO prefetching from other thread would have negative effect. fadvise() call is non-blocking, startup process won't do IO. It just informs kernel to schedule asynchronous page read. On the other hand synchronization with other process might cost more than fadvise(). Anyway cost of calling fadise() once per 16 page reads is neglectable. Thank you! Best regards, Andrey Borodin.
