On Sun, Aug 9, 2009 at 3:26 PM, Fizu<Fizu@xxxxxxxxxxxxxxxxx> 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) An index scan that picks up 1972 rows is taking 5 seconds? I think there must be something wrong with this index. Is it possible that since you apparently weren't analyzing this database, that maybe you didn't vacuum it either? If so, you should probably do a VACUUM FULL on your database and then a database-wide REINDEX, but at a minimum you should try reindexing this particular index. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
