On Wed, 2004-06-09 at 21:45, Christopher Kings-Lynne wrote:
> > If I take away the diagonalSize condition in my query I find that there
> > are 225 rows that satisfy the other conditions.  155 of these have a

> Maybe you should drop your random_page_cost to something less than 4, 
> eg. 3 or even 2...

The big problem is a very poor estimate (off by a couple orders of
magnitude). I was hoping someone with more knowledge in fixing those
would jump in.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to