On Tue, Mar 11, 2014 at 1:24 PM, Parul Lakkad <[email protected]> wrote: > I am trying to figure out when disk is used to store intermediate results > while performing joins in postgres.
Joins can also cause a Nested Loop+Materialize plan, which spills to disk if the materialize result set is too large for work_mem. Regards, Marti -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
