Postgres Pro
Downloads
Home   >   mailing lists

Re: Disk usage for intermediate results in join - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: Disk usage for intermediate results in join
Date
Msg-id CABRT9RBSNMq+eWEJsp70pN95+O3B2ftypzpcfZyGevWA8bY03Q@mail.gmail.com
Whole thread Raw
In response to Disk usage for intermediate results in join  (Parul Lakkad <parul.lakkad@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Upcoming back branch releases
Next
From: Alvaro Herrera
Date:
Subject: Re: Add CREATE support to event triggers Reply-To: