Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-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

pgsql-performance by date

Next:From: clusterDate: 2007-04-17 20:53:51
Subject: Re: FK triggers misused?
Previous:From: Tom LaneDate: 2007-04-17 19:04:57
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

pgsql-hackers by date

Next:From: Jim C. NasbyDate: 2007-04-17 19:26:16
Subject: Re: Autovacuum vs statement_timeout
Previous:From: Tom LaneDate: 2007-04-17 19:04:57
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

pgsql-patches by date

Next:From: Tom LaneDate: 2007-04-17 20:19:04
Subject: Re: log_autovacuum
Previous:From: Bill MoranDate: 2007-04-17 19:10:04
Subject: Re: log_autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group