Re: [PATCH] Prefetch index pages for B-Tree index scans

On Tue, Oct 23, 2012 at 9:44 AM, John Lumby <johnlumby(at)hotmail(dot)com> wrote:
>> From: Claudio Freire <klaussfreire(at)gmail(dot)com>
>> I hope I'm not talking to myself.
>
> Indeed not. I also looked into prefetching for pure index scans for
> b-trees (and extension to use async io).
> http://archives.postgresql.org/message-id/BLU0-SMTP31709961D846CCF4F5EB4C2A3930%40phx.gbl

Yes, I've seen that, though I thought it was only an improvement on
PrefetchBuffer. That patch would interact quite nicely with mine.

I'm now trying to prefetch heap tuples, and I got to a really nice
place where I get an extra 30% speedup even on forward scans, but the
patch is rather green now for a review.

> I am not where I have a proper setup this week but will reply at greater
> length next week.

Great - will go on improving the patch in the meanwhile ;-)