Re: WAL prefetch - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: WAL prefetch
Date
Msg-id CAA4eK1KaA+1ifHgeMcomzFDq5w1PPZYFMB=R7soCXnRAGVwO8A@mail.gmail.com
Whole thread Raw
In response to Re: WAL prefetch  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Responses Re: WAL prefetch
List pgsql-hackers
On Fri, Jun 15, 2018 at 8:45 PM, Konstantin Knizhnik
<k.knizhnik@postgrespro.ru> wrote:
>
> On 15.06.2018 18:03, Amit Kapila wrote:
>
> wal_prefetch is prefetching blocks referenced by WAL records. But in case of
> "full page writes" such prefetch is not needed and even is harmful.
>

Okay, IIUC, the basic idea is to prefetch recently modified data
pages, so that they can be referenced.  If so, isn't there some
overlap with autoprewarm functionality which dumps recently modified
blocks and then on recovery, it can prefetch those?

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Re: [HACKERS] Statement-level rollback
Next
From: Amit Kapila
Date:
Subject: Re: WAL prefetch