> 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.