Keith Gray <keith(at)heart(dot)com(dot)au> writes:
> ...but is it true that if you place the filter clause first,
> the join will not have to complete the whole table?
PG's planner does not pay attention to the ordering of WHERE clauses;
it will do what it thinks best with them in any case.
regards, tom lane