Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> writes: > On Mon, Jun 05, 2006 at 04:07:19PM -0400, Tom Lane wrote: >> I'm wondering about out-of-date or nonexistent ANALYZE stats, missing >> custom adjustments of statistics target settings, etc. > But even the nested loop shouldn't be a "never returns" case, should > it? For 1800 rows? Well, it's a big query. If it ought to take a second or two, and instead is taking an hour or two (1800 times the expected runtime), that might be close enough to "never" to exhaust Chris' patience. Besides, we don't know whether the 1800 might itself be an underestimate (too bad Chris didn't provide EXPLAIN ANALYZE results). The hash plan will scale to larger numbers of rows much more gracefully than the nestloop ... regards, tom lane
