| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve <cheetah(at)tanabi(dot)org> |
| Cc: | pgsql-patches(at)postgreSQL(dot)org, Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Subject: | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |
| Date: | 2007-04-15 05:11:02 |
| Message-ID: | 26103.1176613862@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
Steve <cheetah(at)tanabi(dot)org> writes:
>> 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 :)
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...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lukas Kahwe Smith | 2007-04-15 08:06:03 | Wishlist updates |
| Previous Message | Tom Lane | 2007-04-15 05:01:16 | Re: Server-side support of all encodings |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve | 2007-04-15 08:13:53 | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |
| Previous Message | Steve | 2007-04-14 22:55:45 | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-15 05:29:01 | Re: FK triggers misused? |
| Previous Message | Steve | 2007-04-14 22:55:45 | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |