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) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
