Re: Optimiser desicion bringing system to its knees?

"Craig O'Shannessy" <craig@ucw.com.au> 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