> >actor_full_name_uppercase on actor (cost=0.00..6.01 rows=1 width=42)
> ^^^^^^
> >(actual time=37.62..677.44 rows=3501 loops=1)
> ^^^^^^^^^
> Nick, can you find out why this row count estimation is so far off?
^^^^^^^^^
Oops- I read this backward- I see what you mean now. That's a good question.
I'm not sure what part of the stats this estimate might be pulled from. The
average is 357, but the most common frequency may be around 1.
-Nick
---------------------------(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
