On Tue, Aug 26, 2008 at 5:53 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Frank Joerdens" <frank(at)joerdens(dot)de> writes:
>> It seems to me that the planner makes a very poor decision with this
>> particular query:
>
> Try increasing the stats on woouser. You need it to make a smaller
> estimate of the number of matching rows here:
Way cool, this
alter table webapp_invite alter column woouser set statistics 50;
did the trick, without cleaning up the spurious join there even.
Thanks!
Frank