"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:
> -> Index Scan Backward using webapp_invite_pkey on
> webapp_invite (cost=0.00..201698.51 rows=382 width=44) (actual
> time=2545.131..2545.131 rows=0 loops=1)
> Filter: ((woouser)::text = 'suggus'::text)
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
