Re: Minimally avoiding Transaction Wraparound in VLDBs - Mailing list pgsql-hackers

From David Fetter
Subject Re: Minimally avoiding Transaction Wraparound in VLDBs
Date
Msg-id 20050922065541.GC20409@fetter.org
Whole thread Raw
In response to Re: Minimally avoiding Transaction Wraparound in VLDBs  (Gavin Sherry <swm@linuxworld.com.au>)
Responses Re: Minimally avoiding Transaction Wraparound in VLDBs
List pgsql-hackers
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 david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!


pgsql-hackers by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs
Next
From: Gavin Sherry
Date:
Subject: Parser bug results in ambiguous errors/behaviour