jeandre(at)itvs(dot)co(dot)za writes:
> ... does the order of tables in the from
> clause make a difference in speed
No, it does not; except perhaps in corner cases where two tables have
exactly the same statistics, so that the planner has no basis for
choosing one over the other. (This scenario could happen if you've
never ANALYZEd either, for example.)
> and how does indexing work on Postgres?
Uh, it indexes. What's your question exactly?
regards, tom lane