Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Fix aboriginal mistake in lazy VACUUM's code for truncating away - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Fix aboriginal mistake in lazy VACUUM's code for truncating away
Date
Msg-id 18792.1189918956@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Fix aboriginal mistake in lazy VACUUM's code for truncating away  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-committers
Tree view 
Jan Wieck <JanWieck@Yahoo.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

pgsql-committers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: pgsql: Fix aboriginal mistake in lazy VACUUM's code for truncating away
Next
From: gsmet@pgfoundry.org (User Gsmet)
Date:
Subject: pgfouine - www: added a hint on how to obtain a vacuum log per report