Do we need to perform PostgreSQL clean-up activity after every upgrade

SonarQube 9.9 LTS Upgrade
1

Make sure to tell us:

currently we are in 9.9.2 community edition,

As per the below document do we need to perform Reindexing DB every time or quarterly we can perform, Kindly need your suggestion - Upgrade guide

Thanks!

2

It’s recommended after major/minor version upgrades – and honestly, most professional setups would have this maintenance be running regularly. See the Postgres documentation on Routine Database Maintenance Tasks