On 2019-04-03 23:24, Justin Pryzby wrote: > I just did a test on one of our large-but-not-huge customers. With > stats_target=1, analyzing a 145GB partitioned table looks like it'll take > perhaps an hour; they have ~1TB data, so delaying services during ANALYZE > would > nullify the utility of pg_upgrade. I can restore the essential tables from > backup in 15-30 minutes.
I think the real fix is to have pg_upgrade copy over the statistics. They are right there after all, just take them. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
