"P. Dwayne Miller" <dmiller@espgroup.net> writes:
> Any places to look that might explain the results of explain?
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/performance-tips.html
If you're still confused, feel free to post the query, table schemas,
and EXPLAIN output.
BTW, have you run VACUUM ANALYZE? If not, you're unlikely to get a
good plan.
regards, tom lane