On Tue, 2007-08-14 at 10:10 -0400, Tom Lane wrote: > "Pavan Deolasee" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
