Re: Understanding EXPLAIN ANALYZE output

On Wed, Feb 09, 2005 at 01:11:36PM -0700, Ed L. wrote:
> On Wednesday February 9 2005 12:56, Alvaro Herrera wrote:
> > On Wed, Feb 09, 2005 at 12:54:27PM -0700, Ed L. wrote:
> > > 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.
>
> What delete pattern would cause the problem?

A key on which you insert on one side and delete on the other.  A table
indexed by date, and you regularly delete the oldest entries, for
example.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte"
(Ijon Tichy en Viajes, Stanislaw Lem)