Re: [SQL] left join query does not perform well

2002-08-25 Thread Tom Lane
Manuel Sugawara <[EMAIL PROTECTED]> writes: > Ouch, 3117.48 msec vs. 1.15 msec is a huge difference. I need > something else? or may be postgres optimizer can't cope with > left/right joins? I think the problem is you're constraining the join order into a very inefficient one. See http://www.ca

[SQL] left join query does not perform well

2002-08-24 Thread Manuel Sugawara
Hi all, I have three tables that are related in the following way: ' | epr_ord_grupo < 1 - n > epr_ord_profesor < 0 - n > epr_ord_horario ` In average there is 1.0407716514 rows in epr_ord_horario for each row in e