On Thursday, January 10, 2013 6:09 AM Josh Berkus wrote:
> On 01/09/2013 03:07 PM, Bruce Momjian wrote:
> > How do we want to handle the case where VACUUM FULL clears the
> > visibility map, causing loss of index-only scans?
> > http://archives.postgresql.org/pgsql-performance/2012-
> > Do we document this behavior or add a TODO item?
> Surely VACUUM FULL should rebuild the visibility map, and make tuples
> the new relation all-visible, no?
I think it cannot made all visible.
How about if any transaction in SSI mode is started before Vacuum Full, should it see all tuples.
In response to
pgsql-hackers by date
|Next:||From: Pavan Deolasee||Date: 2013-01-10 06:31:29|
|Subject: Re: 9.2.1 & index-only scans : abnormal heap fetches after
|Previous:||From: Jeff Davis||Date: 2013-01-10 06:06:40|
|Subject: Re: Enabling Checksums|