Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL
Date: 2013-01-10 00:38:36
Message-ID: 50EE0D8C.3080602@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

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