I assumed my indexes were set up properly, but perhaps not. I come from a background where using multi column indexes where used extensively, but after doing some reading, PG apparently can decide to combine single column indexes on its own. If fact, PG might choose to use a sequence scan even if there is an index dependent upon the query.
I think I will be changing multi column indexes to single columns.
Join 30,005+ developers who get early access to new screencasts, articles, guides, updates, and more.