On Tue, Oct 23, 2012 at 9:44 AM, John Lumby <johnlu...@hotmail.com> wrote: >> From: Claudio Freire <klaussfre...@gmail.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 ;-) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers