Ehab Galal <[EMAIL PROTECTED]> 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