Below about 5 to 7%, it will switch to doing an index scan, but above that it will do a sequential scan because sequential reads are much faster. He said something about the kernel doing a prefetch if it understands you doing a sequential read. That's pretty cool. Probably changes if costing affected by, for example, being on an SSD.