> And doing the explicit cross join statement on o_kat_prod instead of
> ot_kat_prod gives the expected performance to me ( 7.42 msec instead
> of 7324.49 msec with EXPLAIN ANALYZE).
>
> Do i've any chance to get the same performance on the view?
I've had this problem and it was due to improper typing - It was a join on
an int8 column, which has to be explicitly cast if it's a parameter to the
query.
Jon
