Re: WAL prefetch

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Sean Chittenden <seanc(at)joyent(dot)com>
Subject: Re: WAL prefetch
Date: 2018-06-14 06:52:51
Message-ID: CAEepm=0fZ02c0ZaU9h-y1rn+QzZWHh=mVHfk0D1vLr0S+Ns6Yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 14, 2018 at 1:09 AM, Konstantin Knizhnik
<k(dot)knizhnik(at)postgrespro(dot)ru> wrote:
> pg_wal_prefetch function will infinitely traverse WAL and prefetch block
> references in WAL records
> using posix_fadvise(WILLNEED) system call.

Hi Konstantin,

Why stop at the page cache... what about shared buffers?

--
Thomas Munro
http://www.enterprisedb.com

In response to

  • WAL prefetch at 2018-06-13 13:09:45 from Konstantin Knizhnik

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Gierth 2018-06-14 06:57:42 Re: ntile() throws ERROR when hashagg is false
Previous Message Rajkumar Raghuwanshi 2018-06-14 06:06:16 ntile() throws ERROR when hashagg is false