"Postgres absolutely does not care [about table order]: the optimizer will always consider both A-join-B and B-join-A orders for every join it has to do. [Y]ou can constrain the join pairs the optimizer will consider if you use explicit-JOIN syntax --- but each pair will be considered in both directions".
