search

vitabaks / postgresql_cluster

PostgreSQL High-Availability Cluster (based on Patroni). Automating with Ansible.
https://postgresql-cluster.org
MIT License
1.69k stars 410 forks source link

pg_upgrade: Use 50% CPU cores for vacuumdb (analyze) #523

Closed vitabaks closed 11 months ago

vitabaks commented 11 months ago

Use 50% CPU cores for vacuumdb (analyze) to minimize the utilization of server resources at the time of statistics collection, since the database can already handle the load from the application.

If necessary, you can change the value of the vacuumdb_parallel_jobs variable.