"P. Dwayne Miller" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html