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
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