On 2015-07-13 21:03:07 +0900, Sawada Masahiko wrote: > Even If we implement rewriting tool for vm into pg_upgrade, it will > take time as much as revacuum because it need whole scanning table.
Why would it? Sure, you can only set allvisible and not the frozen bit, but that's fine. That way the cost for freezing can be paid over time. If we require terrabytes of data to be scanned, including possibly rewriting large portions due to freezing, before index only scans work and most vacuums act in a partial manner the migration to 9.6 will be a major pain for our users. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
