"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 8: explain analyze is your friend
