Re: ORDER BY ... LIMIT and JOIN - Mailing list pgsql-performance

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