| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Understanding EXPLAIN ANALYZE output |
| Date: | 2005-02-09 20:28:28 |
| Message-ID: | 20050209202828.GA16737@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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[(at)]dcc(dot)uchile(dot)cl>)
"El Maquinismo fue proscrito so pena de cosquilleo hasta la muerte"
(Ijon Tichy en Viajes, Stanislaw Lem)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-09 20:40:49 | Re: create temp table and on commit in 7.3.3 |
| Previous Message | Ed L. | 2005-02-09 20:11:36 | Re: Understanding EXPLAIN ANALYZE output |