On Saturday 08 August 2009 08:02:47 Fizu wrote: > -> Index Scan using country_ranking_user_idx on "user" > (cost=0.00..6.49 rows=1 width=145) (actual time=0.023..57.633 > rows=57309 loops=1) > Index Cond: (country_id = 1)
The planner is expecting one user with country_id = 1, but instead there are 57309. Have you analyzed recently? Maybe increasing the statistics target will help. /Michael -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
