Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets
Date
Msg-id 49A65F43.8020700@enterprisedb.com
Whole thread Raw
In response to Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
I haven't been following this thread closely, so pardon if this has been 
discussed already.

The patch doesn't seem to change the cost estimates in the planner at 
all. Without that, I'd imagine that the planner rarely chooses a 
multi-batch hash join to begin with.

Joshua, in the tests that you've been running, did you have to rig the 
planner with "enable_mergjoin=off" or similar, to get the queries to use 
hash joins?

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot standby, recovery procs
Next
From: Simon Riggs
Date:
Subject: Re: Synchronous replication & Hot standby patches