> When you do "explain analyze" of a query that you have difficulties > with, how are the planner's estimates. Are the estimated number of rows > about equal to the actual number of rows?
Some of them are pretty far off. For example -> Merge Left Join (cost=9707.71..13993.52 rows=1276 width=161) (actual time=164.423..361.477 rows=49 loops=1) I tried setting enable_merge_joins to off and that made the query about three times faster. It's using a hash join instead. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster