Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

Поиск
Список
Период
Сортировка
От Steve
Тема Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Дата
Msg-id Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org
обсуждение исходный текст
Ответ на Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
>
> Can you find any cases where it makes a worse choice than before?
> Another thing to pay attention to is whether the planning time gets
> noticeably worse.  If we can't find any cases where it loses badly
> on those measures, I'll feel comfortable in applying it...
>

     I'll see what I can find -- I'll let you know on Monday if I can
find any queries that perform worse.  My tests so far have shown
equivalent or better performance so far but I've only done sort of a
survey so far ... I've got plenty of special cases to test that should
put this through the paces.


Steve

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: build/install xml2 when configured with libxml