Disk usage for intermediate results in join algorithms

From: Parul Lakkad <parul(dot)lakkad(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Disk usage for intermediate results in join algorithms
Date: 2014-03-11 11:24:01
Message-ID: CACmw6hSOpA3H7-x+XpC-8g704JYvsaiRZRrH8a7csG2ViHCywQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jay Riddle 2014-03-11 13:17:32 Re: Disk usage for intermediate results in join algorithms
Previous Message Paul Linehan 2014-03-11 10:45:00 Re: Best method for storing recoverable passwords