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 Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster