Is there an easy way to optimize my postgreSQL database?
Yes, there's two tools we've added to help you with this:
- Optimization - Vacuum/Reindex/Analyze
- Tuning - Scans PC Hardware and updates PostgreSQL config file
Optimization:
Select the database you want to optimize on the left and select an Option on the right.
Warning: This will take a very long time on large databases no matter what option you select on the right. Quick is not quick on a 10mil hand database or a 1 mil hand database. If you have a large database only run this when you can leave your PC on overnight.
- Quick - Vacuum of all tables
- Standard - Vacuum of all tabels and reindex of all indexes
- Full - Vacuum analyze of all tabels and reindex of indexes
Tuning:
This option scans your PC hardware and makes changes to your PostgreSQL config file based on your PC Hardware. It will also create a backup of the original so if anything goes wrong you can easily revert back to your original postgres.config file.
While testing this we noticed Postgres has ram limits, so if you have 8GB of ram on your PC, we can only give postgres so much ram before postgres crashes. Postgres gives very little Ram to certain things so this tool should help if you have a nice PC. Just don't expect it to go from Prius speed to Ferrari speed by running this tool.