Re: Understanding EXPLAIN ANALYZE output

On Wed, Feb 09, 2005 at 12:54:27PM -0700, Ed L. wrote:
> On Wednesday February 9 2005 12:04, you wrote:

> > 4796.0 ms are the time it took for 34's index scan to complete
> > the 1014 loops, I'd think.
>
> Interesting.  Reindexing the index
>
>     idx_queryoutcome_occurrencehistory_key
>
> sped up the query to sub-second.  This is a 7.3.4 cluster.  I
> wonder if this that 7.3 index bloat bug?

Hard to say, because you didn't provide more info (such as if the index
has the right deletion pattern), but it could be.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"I call it GNU/Linux. Except the GNU/ is silent." (Ben Reiter)