On Wed, 2007-03-14 at 10:28 -0700, Timothy J. Kordas wrote:
> I would expect for the same data a hash-join with a work_mem of 256MB
> to run faster than one run with 32MB; even if the inner relation is
> only 30MB.
Certainly not for all data, but for some distrubutions yes, probably.
The easiest thing to do is prove thats true and then work out how to
spot that case ahead of time, or at least find a place where you can
adjust your assumptions cheaply enough to improve things.
-- Simon Riggs EnterpriseDB http://www.enterprisedb.com