Postgres Pro
Downloads
Home   >   mailing lists

Disk usage for intermediate results in join algorithms - Mailing list pgsql-novice

From Parul Lakkad
Subject Disk usage for intermediate results in join algorithms
Date
Msg-id CACmw6hSOpA3H7-x+XpC-8g704JYvsaiRZRrH8a7csG2ViHCywQ@mail.gmail.com
Whole thread Raw
Responses Re: Disk usage for intermediate results in join algorithms  (Jay Riddle <jcriddle4@yahoo.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Paul Linehan
Date:
Subject: Re: Best method for storing recoverable passwords
Next
From: Jay Riddle
Date:
Subject: Re: Disk usage for intermediate results in join algorithms