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