I'm upgrading from 9.5 to 9.6. Running vacuum analyze on the whole db to regenerate stats is a pain. Is there any way to upgrade and migrate over the statistics so I dont have to regenerate them?

  • 2
    Not AFAIK. pg_upgrade won't move them, and backup and restore won't either. This post seems to agree with this fact. It will also suggest alternatives to ANALYZE faster.
    – joanolo
    Mar 16 '17 at 23:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.