Project

General

Profile

Actions

Task #539

closed

get analytical_stem_view to use merge joins instead of hash joins

Added by Aaron Marcuse-Kubitza over 11 years ago. Updated about 10 years ago.

Status:
Rejected
Priority:
Normal
Start date:
12/03/2012
Due date:
% Done:

0%

Estimated time:
Activity type:

Description

  • This will speed up the joins, which used to take 0.5 hour but now take 2.5 hours
  • It will also reduce the disk space used by hash joins
Actions #1

Updated by Aaron Marcuse-Kubitza about 10 years ago

  • Status changed from New to Rejected

the query planner is likely right that hash joins are faster when joining entire tables rather than just the first few rows

Actions

Also available in: Atom PDF