I wrote: > Thanks. After digging through it a bit, I understand what's happening, > but I'm not seeing any simple fix. I forgot to mention that although I could reproduce your bad plan in 8.1, CVS HEAD doesn't fall into the trap. I don't believe we've done anything to fix the fundamental problem however --- it may just be a side effect of the changes in the indexscan cost model that cause it to not go for the bogus plan. regards, tom lane
