Fernando Schapachnik <fernando@xxxxxxxxxxxx> writes: > En un mensaje anterior, Tom Lane escribió: >> Is this query really what you want to do? Because the OR overrides all >> the join conditions, meaning that rows having p.id_cola_por_ambito=1 >> AND p.id_situacion!=6 must produce Cartesian products against every >> row in each of the other tables. > Yes, yes, we found this while working on improving the query. I just > wanted to point out that the optimizer was doing a sequential scan > in a situation it could unfould de active_users definition, add the > login='xxx' clause, and use the index on the users table. What for, when the query requires fetching the entire table anyway? regards, tom lane
