Zach Calvert <zachcalvert@hemerasoftware.com> writes:
> I've added the leaderboardid, score index and it still does the
> sequential scan. I'm going to try inserting a few hundred thousand
> rows and seeing if it switches to index scan.
You didn't answer the critical question, which is what fraction of the
table rows this query selects. If it's a large fraction then the
planner never will switch to indexscan, no matter what the table size
--- and it'll be doing the right thing. Indexscans aren't magic.
regards, tom lane