On Tue, Mar 11, 2014 at 1:24 PM, Parul Lakkad parul.lak...@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
Hi,
I am trying to figure out when disk is used to store intermediate results
while performing joins in postgres.
According my findings using 'explain analyse ' only merge sort uses disk.
Can anyone please throw some more light on this?
Thanks,
Parul
On 03/11/2014 01:24 PM, Parul Lakkad wrote:
Hi,
I am trying to figure out when disk is used to store intermediate results
while performing joins in postgres.
According my findings using 'explain analyse ' only merge sort uses disk.
Can anyone please throw some more light on this?
Hash joins