Wei Weng <wweng@kencast.com> writes:
> I have a massive join that takes something like 10 seconds to execute in
> Postgresql 7.2. Can any of gurus here help me improve it?
1. Have you vacuum analyzed these tables lately? The row count
estimates look suspiciously low.
2. Please provide EXPLAIN ANALYZE output not just EXPLAIN.
regards, tom lane