On Thu, Jun 2, 2011 at 4:57 PM, Kevin Grittner <kevin.gritt...@wicourts.gov> wrote: > And the > planner does take the size of work_mem and the expected data set > into consideration when estimating the cost of the hash join.
And shouldn't it? In a gross mode, when hash joins go to disk, they perform very poorly. Maybe the planner should take that into account. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
