Postgres Full Vacuum for slow performance

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Slow performance in PostgreSQL database, certain queries take longer, a large bloat on selected tables causing a slowdown

Environment

Release : Any

Resolution

Full vacuum needs a downtime on the environment, without downtime it can cause performance issues. Do not run full vacuum without a downtime and bringing the application to stop

1. Request maintenance downtime
2. Stop application services
3. Determine which tables have a high bloat
4. Run full vacuum on the environment
   vacuum full
5. Bring the services back up

Additional Information

PostgreSQL Documentation on Vacuum