Re: Optimiser desicion bringing system to its knees?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Optimiser desicion bringing system to its knees?
Дата
Msg-id 24501.1068167216@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Optimiser desicion bringing system to its knees?  (Craig O'Shannessy <craig@ucw.com.au>)
Ответы Re: Optimiser desicion bringing system to its knees?  ("Craig O'Shannessy" <craig@ucw.com.au>)
Список pgsql-general
"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

В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: int8 primary keys still not using index without manual JDBC driver patch (7.4RC1)
Следующее
От:
Дата:
Сообщение: on connect trigger