As time goes by: When joins spill to disk

Large joins may use full scans and hash joins. If your tables are large enough, this will fill up your process working memory and start spilling to your temp-tablespace. At that time a few important effects come into play:

Continue reading “As time goes by: When joins spill to disk”