This is part two of a three part series examining the different ways Postgres can fetch rows from a table.

Usually a sequential scan winds up being pretty slow. A sequential scan needs to read the entire table in order … Read the rest

This is part one of a three part series on the main ways Postgres has of fetching rows from a table. 

Of the three main ways Postgres has fetching rows from a table, a sequential scan is the most basic. … Read the rest