Ahh, this makes sense.
I've recently changed this into a partial index because I was getting
awful performance on it.
Thanks Tom, this gives me a stopgap fix until I can get 7.4 into
production.
Craig
On Thu, 6 Nov 2003, Tom Lane wrote:
> "Craig O'Shannessy" <[EMAIL PROTECTED]> writes:
> > The explains below make it clear I think. If I just change the table
> > declaration order, I get MASSIVELY better performance.
>
> Hm. Is the lineitem_sku_reservation_idx index a partial index, by any
> chance? I see this bug fix in 7.2.2:
>
> 2002-08-22 12:20 tgl
>
> * src/backend/optimizer/path/indxpath.c (REL7_2_STABLE): Back-patch
> fix to make partial indexes usable on relations other than the
> first one listed in a query. Per request from Oleg.
>
> regards, tom lane
>
---------------------------(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
