Manuel,
> I'm facing a wired problem. When I left join two tables PostgreSQL is
> able to do it fast using the corresponding indices, However, if I
> define a simple view (to format the data) on one of the tables, the
> left join does not use the indices. Is something wrong here?
At a guess, the complex CASE statements are causing the planner to behave
badly. What happens if you do a straight join and not a left join?
Also, it's generally a good idea to put your join expression in the same order
as the referenced tables. You confused me and you could confuse the planner
at some stage.
--
-Josh BerkusAglio Database SolutionsSan Francisco