On Tue, Aug 26, 2008 at 5:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Frank Joerdens" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
