Re: *very* inefficient choice made by the planner (regarding

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: *very* inefficient choice made by the planner (regarding
Date: 2004-06-10 15:00:28
Message-ID: 20040610075749.G17875@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Thu, 10 Jun 2004, Frank van Vugt wrote:

> Could anybody explain why the planner is doing what it is doing?
>
> What could I do to make it easier to choose a better plan?

You might try raising sort_mem to see if it chooses a better plan. I
think it may be guessing that the hash won't fit and falling back to the
plan you were getting.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-06-10 15:19:35 Re: *very* inefficient choice made by the planner (regarding IN(...))
Previous Message Frank van Vugt 2004-06-10 14:24:21 *very* inefficient choice made by the planner (regarding IN(...))