On Tue, 2005-11-29 at 09:45 -0500, Pollard, Mike wrote: > Anyway, what I did was the following. When doing a sequential scan, we > were starting at the beginning of the table and scanning forward. If I > threw up some threads to read ahead, then my user thread and my read > ahead threads would thrash on trying to lock the buffer slots. So, I > had the read ahead threads start at some distance into the table, and > work toward the beginning.
I believe this is commonly called a synchronous scan. -jwb ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
