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