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

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

In response to

Browse pgsql-hackers by date

  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)

Browse pgsql-patches by date

  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

Browse pgsql-performance by date

  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)