Re: Press Release - Mailing list pgsql-advocacy

From Bruce Momjian
Subject Re: Press Release
Date
Msg-id 200310292307.h9TN7uv10199@candle.pha.pa.us
Whole thread Raw
In response to Re: Press Release  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Press Release  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-advocacy
Robert Treat wrote:
> On Wed, 2003-10-29 at 17:24, Josh Berkus wrote:
> > If anybody has evidence that the FSM index management doens't work, then we'll
> > cut the paragraph.  However, I'm inclined to trust Tom & Co., and my only
> > simple tests seemed to uphold the Lazy-Vacuum-ability of indexes.
>
> Tom has laid out at least one case where the potential for index growth
> exits, though I don't see it in a quick search of the archives...
>
> Tom, can you weigh in here?

If you delete all but one row on every index page, I think.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-advocacy by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Press Release
Next
From: "scott.marlowe"
Date:
Subject: Re: Press Release