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

2007-04-16 Thread Steve
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... Okay, here's the vedict; all the

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

2007-04-15 Thread Steve
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

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

2007-04-14 Thread Steve
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