From: | Steve <cheetah(at)tanabi(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |
Date: | 2007-04-17 19:19:25 |
Message-ID: | Pine.GSO.4.64.0704171510020.11186@kittyhawk.tanabi.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches pgsql-performance |
>> Maybe it would be interesting to see in detail those cases that got a
>> bit slower, to further tweak the heuristic if necessary. Is the extra
>> time, time spent in planning or in execution?
>
> Since there doesn't seem to be vast interest out there in testing this
> further, I'm going to go ahead and apply the patch to get it out of my
> working directory. We can always tweak it more later if new info
> surfaces.
>
Doing my routine patching seems to have exploded my mail server,
sorry for not replying sooner!
I don't actually have planning vs. execution time statistics from
the older version for the queries in question -- there were not 'problem
queries' and therefore were never really analyzed. My customer's already
dragging me off to another issue, so I've got to shift gears.
Appreciate all your work -- thanks again!!! :)
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2007-04-17 19:26:16 | Re: Autovacuum vs statement_timeout |
Previous Message | Tom Lane | 2007-04-17 19:04:57 | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-04-17 20:19:04 | Re: log_autovacuum |
Previous Message | Bill Moran | 2007-04-17 19:10:04 | Re: log_autovacuum |
From | Date | Subject | |
---|---|---|---|
Next Message | cluster | 2007-04-17 20:53:51 | Re: FK triggers misused? |
Previous Message | Tom Lane | 2007-04-17 19:04:57 | Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance) |