Re:Major features of PostgreSQL 9.6 [pdf]
by dunkelheit on Monday September 26, 2016 @04:25AM
(#12580166)
> I thought a sequential scan was slow because it was limited by disk I/O
Not necessarily. Suppose you have a fairly big table that fits in the shared buffer cache and you run a query with a predicate that returns only a handful of rows. Then you would be better off scanning parts of it in parallel and then combining the results.
Not necessarily. Suppose you have a fairly big table that fits in the shared buffer cache and you run a query with a predicate that returns only a handful of rows. Then you would be better off scanning parts of it in parallel and then combining the results.