Re: pgsql: Fix aboriginal mistake in lazy VACUUM's code for truncating away

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Fix aboriginal mistake in lazy VACUUM's code for truncating away
Date: 2007-09-16 05:02:36
Message-ID: 18792.1189918956@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Jan Wieck <JanWieck(at)Yahoo(dot)com> writes:
> On 9/15/2007 10:37 PM, Tom Lane wrote:
>> Fix aboriginal mistake in lazy VACUUM's code for truncating away
>> no-longer-needed pages at the end of a table.

> You mean symptoms like multiple index tuples pointing to the same heap
> tuple, thus presenting the same heap tuple twice during an index scan,
> don't you?

Yup, exactly :-(

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message User Gsmet 2007-09-16 09:10:07 pgfouine - www: added a hint on how to obtain a vacuum log per report
Previous Message Jan Wieck 2007-09-16 04:10:42 Re: pgsql: Fix aboriginal mistake in lazy VACUUM's code for truncating away