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-11/msg00317.php
> 
> Do we document this behavior or add a TODO item?
> 

Both?

Surely VACUUM FULL should rebuild the visibility map, and make tuples in
the new relation all-visible, no?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

• 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL at 2013-01-09 23:07:31 from Bruce Momjian

Responses

• Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL at 2013-01-10 06:15:47 from Amit Kapila
• Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL at 2013-01-10 06:31:29 from Pavan Deolasee

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2013-01-10 00:56:57
	Subject: Re: PL/perl should fail on configure, not make
Previous:	From: Ian Lawrence Barwick	Date: 2013-01-10 00:35:10
	Subject: Small clarification in "34.41. schemata"