Re: HOT patch, missing things

On 8/9/07, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>
> On Thu, 2007-08-09 at 15:46 +0530, Pavan Deolasee wrote:
> >
>
> > 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.
> >
> > We can some fine tuning to track the space consumed by redirect-dead
> > line pointers.
>
> Sounds great.
>
>
>
So do we have consensus here ? Fortunately, I think there won't be any
changes to user interface. Users can still use the vacuum_scale_factor to
tune autovacuum, but instead of percentage of dead tuples, it would
signify percentage of dead space in the relation.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB http://www.enterprisedb.com