Re: Migration study, step 2: rewriting queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Migration study, step 2: rewriting queries
Дата
Msg-id 20147.1145237750@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Migration study, step 2: rewriting queries  ("Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com>)
Список pgsql-performance
"Mikael Carneholm" <Mikael.Carneholm@WirelessCar.com> writes:
> ..and this last AND seems unnessecary, since the predicate on
> (driver_activity_type__id = 5) is included in each of the above
> conditions.

This should be fixed by the changes I made recently in choose_bitmap_and
--- it wasn't being aggressive about pruning overlapping AND conditions
when a sub-OR was involved.  It's possible the new coding is *too*
aggressive, and will reject indexes that it'd be profitable to include;
but at least it won't make this particular mistake.

            regards, tom lane

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

Предыдущее
От: "Mikael Carneholm"
Дата:
Сообщение: Migration study, step 2: rewriting queries
Следующее
От: Cris Carampa
Дата:
Сообщение: index is not used if I include a function that returns current time in my query