> The outer join seems unnecessarily slow. Is there anything I can do
> to speed it up?
>
> PostgreSQL 8.1.3 on OS X (MacPorts).
This is just a guess on my part, but would it help if you preformed the inner
join first to filter
out the most of the unwated rows that then preform the outer join with what is
left over?
But just double check that results are as you expect.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
