Re: Optimising a query

Paul Lambert wrote:
> "                                            ->  Merge Join
> (cost=35.56..19732.91 rows=12 width=48) (actual time=0.841..2309.828
> rows=206748 loops=1)"

I'm no expert, but in the interests of learning: why is the
rows estimate so far out for this join?

Thanks,
    Jeremy