On Tue, Dec 19, 2006 at 10:37:21AM -0800, Jeff Davis wrote: > > leader is doing a nested loop and the follower which is just doing a > > straight > > sequential scan is being held back? > > > > The follower will never be held back in my current implementation. > > My current implementation relies on the scans to stay close together > once they start close together. If one falls seriously behind, it will > fall outside of the main "cache trail" and cause the performance to > degrade due to disk seeking and lower cache efficiency.
That's something else that it would be really good to have data for; in some cases it will be better for the slow case to just fall behind, but in other cases the added seeking will slow everything down enough that it would have been faster to just stay at the speed of the slow scan. The question is where those two thresholds are... -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
