Skip to content

Add further postgres ANALYZE debugging to pg-upgrade docs

DJ Mountney requested to merge analyze-doc into master

What does this MR do?

Adds information to the pg-upgrade docs around the use of ANALYZE and steps to run it yourself in case of an error.

In previous upgrades we have had issues with statement timeout on large dbs that required support/users to run this. Hopefully these will become uncommon with the changes in !5121 (merged) but these docs will still be important for anyone using pg-upgrade on a GitLab version prior to 13.11.

Related issues

Closes #5363 (closed)

Checklist

See Definition of done.

For anything in this list which will not be completed, please provide a reason in the MR discussion

Required

  • Merge Request Title, and Description are up to date, accurate, and descriptive
  • MR targeting the appropriate branch
  • MR has a green pipeline on GitLab.com
  • Pipeline is green on dev.gitlab.org if the change is touching anything besides documentation or internal cookbooks
  • trigger-package has a green pipeline running against latest commit

Expected (please provide an explanation if not completing)

  • Test plan indicating conditions for success has been posted and passes
  • Documentation created/updated
  • Tests added
  • Integration tests added to GitLab QA
  • Equivalent MR/issue for the GitLab Chart opened
Edited by DJ Mountney

Merge request reports