On Mon, Jun 05, 2006 at 04:07:19PM -0400, Tom Lane wrote: > > broke: > > -> Nested Loop (cost=30150.77..129334.04 rows=1 width=305) > > work: > > -> Hash Join (cost=30904.77..125395.89 rows=1810 width=306) > > 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? (I've _had_ bad plans that picked nestloop, for sure, but they're usually for tens of thousands of rows when they take forever). A -- Andrew Sullivan | ajs@xxxxxxxxxxxxxxx Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz
