Re: [PATCHES] Merge join performance

2006-08-23 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > We can make markpos fast, if we make the copy lazily in _bt_steppage, Nice hack. Getting rid of the buffer refcount manipulations is probably even more useful than avoiding the memcpy. > I did some micro-benchmarking of merge join performance, se

[PATCHES] Merge join performance

2006-08-23 Thread Heikki Linnakangas
It seems that the page-at-a-time-index-scan patch applied in the spring caused a slight performance regression to merge joins. The btree mark/restore became much more expensive, as btmarkpos now has to copy the array of item pointers retrieved from the current index page. That adds up, because