Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL
Date
Msg-id 50EE0D8C.3080602@agliodbs.com
Whole thread Raw
In response to 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL  (Bruce Momjian <bruce@momjian.us>)
Responses Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Index build temp files
Next
From: Tom Lane
Date:
Subject: Re: PL/perl should fail on configure, not make