Oleg,

> The output of the query should contain about 200 rows. So, I guess the
> planer is off assuming that the query should return 1 row.

Oh, also did you post the query before?   Can you re-post it with the planner 
results?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to