Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) - Mailing list pgsql-patches

From Steve
Subject Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Date
Msg-id Pine.GSO.4.64.0704141830490.17955@kittyhawk.tanabi.org
Whole thread Raw
In response to Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)