Ehab Galal <ehabgalal123@hotmail.com> writes: > I was wondering why do we need the Materialize node in the plan below when i explain a query? It's cheaper to scan a materialized rowset many times than a raw table --- we don't need to re-access shared memory nor re-check row visibility. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings