On Thu, Sep 22, 2005 at 03:52:21PM +1000, Gavin Sherry wrote: > On Wed, 31 Aug 2005, Tom Lane wrote: > > > BTW ... the original Berkeley papers on Postgres make frequent reference > > to a "vacuum daemon", which seems to be essentially what we're trying to > > build with autovacuum. Does anyone know if the Berkeley implementation > > ever actually had auto vacuuming, or was that all handwaving? If it did > > exist, why was it removed? > > Well, I was just poking around the executor and noticed this in > ExecDelete(): > > /* > * Note: Normally one would think that we have to delete index tuples > * associated with the heap tuple now.. > * > * ... but in POSTGRES, we have no need to do this because the vacuum > * daemon automatically opens an index scan and deletes index tuples > * when it finds deleted heap tuples. -cim 9/27/89 > */
I have an idea who this might be :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
