4. Upgrading Using Unload/Reload : How You Perform an Upgrade Using Unload/Reload : (Optional) Print Optimizer Statistics
 
Share this page                  
(Optional) Print Optimizer Statistics
Note:  This step applies only to a clean-install upgrade.
Print optimizer statistics for each database. If your upgrade plan allows enough downtime to run a full optimizedb against your databases, you can omit this step. If your plan does not allow enough downtime, perform this step as a shortcut.
Note:  Using this shortcut may result in some of the new Ingres metrics not being available; query performance may suffer until a full optimizedb can be completed.
If you are upgrading from OpenIngres 1.x, you should regenerate new statistics instead of saving the old ones, if possible.
To print the existing optimizer statistics, run statdump with the -o flag to a file for each database, as follows:
statdump -o dbname.stats dbname