Optimize a database

Sections

If your databases are slow, begin taking up too much disk space, or need general performance enhancements, use the PostgreSQL vacuum command to optimize any of the PE databases.

To optimize a database, run: su - pe-postgres -s /bin/bash -c "/opt/puppetlabs/server/apps/postgresql/bin/vacuumdb -z --verbose <DATABASE NAME>"
How helpful was this page?
Puppet sites use proprietary and third-party cookies. By using our sites, you agree to our cookie policy.