Re: Minimally avoiding Transaction Wraparound in VLDBs

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, Cimarron Taylor <cimarron(at)christopherrobin(dot)kolo(dot)net>
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs
Date: 2005-09-22 07:15:26
Message-ID: 1D4141D0-F12E-4234-AFBA-21635BE27017@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Sep 22, 2005, at 3:55 PM, David Fetter wrote:

> On Thu, Sep 22, 2005 at 03:52:21PM +1000, Gavin Sherry wrote:
>
>> On Wed, 31 Aug 2005, Tom Lane wrote:
>>
>> 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 :)

giof

http://www.taylors.org/cim/resume/cimarron.html

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-09-22 09:11:50 Re: Table Partitioning is in 8.1
Previous Message Gavin Sherry 2005-09-22 06:56:26 Parser bug results in ambiguous errors/behaviour