| From: | Steve <cheetah(at)tanabi(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 08:13:53 |
| Message-ID: | Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches pgsql-performance |
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2007-04-15 11:09:42 | Re: Server-side support of all encodings |
| Previous Message | Lukas Kahwe Smith | 2007-04-15 08:06:03 | Wishlist updates |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2007-04-15 17:22:13 | Re: build/install xml2 when configured with libxml |
| Previous Message | Tom Lane | 2007-04-15 05:11:02 | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-15 15:22:43 | Re: FK triggers misused? |
| Previous Message | Andrew - Supernews | 2007-04-15 05:42:49 | Re: FK triggers misused? |