Re: Optimising a query

From: Jeremy Harris <jgh(at)wizmail(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimising a query
Date: 2007-12-19 17:12:08
Message-ID: 476950E8.50009@wizmail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2007-12-19 18:50:29 Re: Dual core Opterons beating quad core Xeons?
Previous Message Alvaro Herrera 2007-12-19 15:55:31 Re: viewing source code