Re: [PATCH] Prefetch index pages for B-Tree index scans
Claudio Freire <klaussfreire@gmail.com>
From: Claudio Freire <klaussfreire@gmail.com>
To: John Lumby <johnlumby@hotmail.com>
Cc: pgsql hackers <pgsql-hackers@postgresql.org>
Date: 2012-10-29T15:56:54Z
Lists: pgsql-hackers
Attachments
- postgresql-git-bt_fullfetch.diff (application/octet-stream) patch
On Mon, Oct 29, 2012 at 12:53 PM, Claudio Freire <klaussfreire@gmail.com> wrote: >> 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 ;-) > > Ok, this is the best I could come up with, without some real test hardware. Oops - forgot to effectively attach the patch.