pg_upgrade and visibility map files

Started by Bruce Momjianover 13 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

I have found an odd mistake in pg_upgrade 9.2, though I don't think it
is a problem. Specifically, pg_upgrade will copy a visibility map (vm)

1GB extent file from the old cluster to the new, even if the

crash-safety of the old vm file does not match the new server. For
example, 19323_vm would not be copied, but 19323_vm.1 would be.

I don't think this is a problem because having a >1GB vm file would
require the table to be 64TB (1GB * 8 * 8k), and our max table size is
32TB. I am not planning to fix this in 9.2; this code is restructured
in git head and does not have this problem.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +