On Thu, 2007-03-01 at 14:35 +0100, Zeugswetter Andreas ADI SD wrote:
> > -- start the VACUUM from the first non-filled block
> > So if we do this, we wouldn't need to worry about HOT tuples
> > at all, nor would we need to wait until all transactions are gone.
> You need to wait until you are allowed to truncate if you want
> Or a concurrent scan might miss a row, because the visible tuple got
> truncated away.
I was not suggesting that we remove visible rows through truncation.
In response to
pgsql-hackers by date
|Next:||From: Pavan Deolasee||Date: 2007-03-01 13:49:46|
|Subject: HOT - preliminary results|
|Previous:||From: Hannu Krosing||Date: 2007-03-01 13:40:04|
|Subject: Re: Revitalising VACUUM FULL for 8.3|