On Sunday 09 August 2009 21:26:08 Fizu wrote:
>-> Index Scan using country_ranking_user_idx on "user"
> (cost=0.00..4807.25 rows=1710 width=143) (actual
> time=20.923..4898.931 rows=1972 loops=1)
> Index Cond: (country_id = 5)
The statistics looks good now, b
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
