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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 IN(...))
Date: 2004-06-10 15:19:35
Message-ID: 24880.1086880775@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl> writes:
> What could I do to make it easier to choose a better plan?

Increase sort_mem. You want it to pick a "hashed subplan", but
it's not doing so because 64000 rows won't fit in the default
sort_mem.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Frank van Vugt 2004-06-10 15:32:08 Re: *very* inefficient choice made by the planner (regarding IN(...))
Previous Message Stephan Szabo 2004-06-10 15:00:28 Re: *very* inefficient choice made by the planner (regarding