Zach Calvert wrote:
Still getting a seq scan after doing vacuum analyze. Any other ideas?
Try CLUSTERing the table on the (leaderboardid, active, score) index. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
