How do I know if I need to run any of VACUUM, REINDEX, ANALYSE? Because I don't want to run this every day even if it is not needed.

For example, is it a good option to run all of above after 100 updates?

Is there some query that will tell me "Yes, you need to run Vacuum on table xyz"? Something like self analysis for performance optimization.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.