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.0704141830490.17955@kittyhawk.tanabi.org
обсуждение исходный текст
Ответ на Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Список pgsql-patches
Дерево обсуждения 
> Steve, can you try this out on your queries and see if it makes better
> or worse decisions?  It seems to fix your initial complaint but I do
> not have a large stock of test cases to try.
>

     Wow, this is a remarkable difference.  Queries that were taking
minutes to complete are coming up in seconds.  Good work, I think this'll
solve my customer's needs for their demo on the 19th :)

Thank you so much!


Steve

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

Предыдущее
От: Zoltan Boszormenyi
Дата:
Сообщение: Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)