Re: Use fadvise in wal replay - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Use fadvise in wal replay
Date
Msg-id D5E10736-D306-4BD8-86C4-49129CDFE27F@yandex-team.ru
Whole thread Raw
In response to Re: Use fadvise in wal replay  (Amit Kapila <amit.kapila16@gmail.com>)
Responses RE: Use fadvise in wal replay
Re: Use fadvise in wal replay
List pgsql-hackers

> On 21 Jun 2022, at 12:35, Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> I wonder if the newly introduced "recovery_prefetch" [1] for PG-15 can
> help your case?

AFAICS recovery_prefetch tries to prefetch main fork, but does not try to prefetch WAL itself before reading it. Kirill
istrying to solve the problem of reading WAL segments that are our of OS page cache. 

Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Devel docs on website reloading
Next
From: Aleksander Alekseev
Date:
Subject: Re: Make COPY extendable in order to support Parquet and other formats