On Tue, 2007-08-14 at 10:10 -0400, Tom Lane wrote:
> "Pavan Deolasee" <pavan.deolasee@gmail.com> writes:
> > What if we just track the amount of potentially dead space in the
> > relation
> > (somebody had suggested that earlier in the thread) ? Every committed
> > UPDATE/DELETE and aborted UPDATE/INSERT would increment
> > the dead space. Whenever page fragmentation is repaired, either during
> > normal operation or during vacuum, the dead space is reduced by the
> > amount of reclaimed space. Autovacuum triggers whenever the percentage
> > of dead space increases beyond a threshold.
>
> Doesn't this design completely fail to take index bloat into account?
> Repairing heap fragmentation does not reduce the need for VACUUM to work
> on the indexes.
I thought of that, but we will only clean up space that is allowable, so
the indexes don't degrade.
-- Simon Riggs EnterpriseDB http://www.enterprisedb.com