Re: Extended Prefetching using Asynchronous IO - proposal and patch

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: John Lumby <johnlumby(at)hotmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql hackers <pgsql-hackers(at)postgresql(dot)org>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Subject: Re: Extended Prefetching using Asynchronous IO - proposal and patch
Date: 2014-05-29 22:16:06
Message-ID: CAGTBQpYTp_QuWLQpxxNjoWC5Au9MKnxNHCcoOcNtVToPJtjzLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, May 29, 2014 at 7:11 PM, John Lumby <johnlumby(at)hotmail(dot)com> wrote:
>> Nonetheless, getting the next tid out of the index may involve stepping
>> to the next index page, at which point you've lost your interlock
>
> I think we are ok as peeknexttuple (yes bad name, sorry, can change it
> ...
> never advances to another page :
>
> * btpeeknexttuple() -- peek at the next tuple different from any
> blocknum in pfch_list
> * without reading a new index page
> * and without causing any side-effects such as
> altering values in control blocks
> * if found, store blocknum in next element of pfch_list

Yeah, I was getting to that conclusion myself too.

We could call it amprefetchnextheap, since it does just prefetch, and
is good for nothing *but* prefetch.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2014-05-29 22:18:10 Re: Extended Prefetching using Asynchronous IO - proposal and patch
Previous Message Claudio Freire 2014-05-29 22:14:36 Re: Extended Prefetching using Asynchronous IO - proposal and patch

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2014-05-29 22:18:10 Re: Extended Prefetching using Asynchronous IO - proposal and patch
Previous Message Claudio Freire 2014-05-29 22:14:36 Re: Extended Prefetching using Asynchronous IO - proposal and patch