The instructions for Optimizing the Database (https://docs.puppetlabs.com/pe/latest/maintain_console-db.html#optimizing-the-database) are not detailed or clear enough.
The documents states that by default autovacuum=on, however the documentation does not specify which file to check this setting. Also, by default the file is a sample file
/opt/puppet/share/postgresql/postgresql.conf.sample, and will need to be edited.
The instructions are also potentially misleading in cases where pe-postgresql doesn't install with autovacuum enabled.
From Zendesk ticket: 7404.