Forum OpenACS Q&A: Response to What expectations/settings should I have for Postgres?

Actually indexes won't help these queries - he's looking at the entire table.  Indexes only help when you're slicing bits out of a table or in some RDBMS systems (but not PG) when you're doing queries that only  involve the column(s) in the index.