| From: | Claudio Freire <klaussfreire(at)gmail(dot)com> |
|---|---|
| To: | John Lumby <johnlumby(at)hotmail(dot)com> |
| Cc: | pgsql hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [PATCH] Prefetch index pages for B-Tree index scans |
| Date: | 2012-10-29 15:56:54 |
| Message-ID: | CAGTBQpZd_Z=T2kpPEmzyfmqgMXwSnC_8REuNyOgbLio+DL_H3Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Oct 29, 2012 at 12:53 PM, Claudio Freire <klaussfreire(at)gmail(dot)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.
| Attachment | Content-Type | Size |
|---|---|---|
| postgresql-git-bt_fullfetch.diff | application/octet-stream | 14.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2012-10-29 16:26:22 | Re: Is there a way to test for UNASSIGNED in pl/pgsql |
| Previous Message | Claudio Freire | 2012-10-29 15:53:22 | Re: [PATCH] Prefetch index pages for B-Tree index scans |