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

Reply via email to