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