|Pivotal Greenplum||18.104.22.168 and below|
When backing up a database using gprondump with the "-dump-stats" option, the time to complete the backup may take a very long time.
Note: The output from the command will show the start of the statistics gathering the following:
gpcrondump:mdw:gpadmin-[INFO]:-Commencing pg_statistic dump
Improvements have been made in 22.214.171.124 and above. The following is from the 126.96.36.199 Release Notes:
- Performance has been improved for the Greenplum Database gpcrondump utility when the --dump-stats option is specified to backup database statistics. Performance has been significantly improved by caching the connection to the database instead of opening new connections when gpcrondump backs up database statistics.