Re: [PERFORM] The order of fields around the "=" in the WHERE

version PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.6 (1 row) -- After commutator added to operators of user defined type, -- the orde

Re: [PERFORM] The order of fields around the "=" in the WHERE

The datatype of the join columns is a user defined type and there are no commutators defined. I will fix that and retest. Thanks for the insight. Mike Quinn ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://w

Re: [PERFORM] The order of fields around the "=" in the WHERE conditions

"Mike Quinn" <[EMAIL PROTECTED]> writes: > -- The order of fields around the "=" in the WHERE conditions > -- affects the query plan. BTW, what's the datatype(s) of the join columns? The behavior looks consistent with the idea that the planner doesn't think it can commute the join conditions, whi

Re: [PERFORM] The order of fields around the "=" in the WHERE conditions

"Mike Quinn" <[EMAIL PROTECTED]> writes: > -- The order of fields around the "=" in the WHERE conditions > -- affects the query plan. That absolutely should not be happening. Could we see a complete test case? regards, tom lane ---(end of broadcas

[PERFORM] The order of fields around the "=" in the WHERE conditions

version PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.6 (1 row) -- The order of fields around the "=" in the WHERE conditions -- affect