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 (<[EMAIL PROTECTED]>) "El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte" (Ijon Tichy en Viajes, Stanislaw Lem) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
