On Tue, Mar 11, 2014 at 1:24 PM, Parul Lakkad <parul.lakkad@gmail.com> 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