Videos / Other Resources

No attachments were found.

Postgres Optimization

Overview:

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
To get to these options, click Options/Database Management inside of Holdem Manager.  This takes you to Database Control Panel.  Click "Connect."  On this screen, click the "Optimize" button.



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. 




| More

Related Articles


User Opinions (54 votes)

87% thumbs up 12% thumbs down

How would you rate this answer?



Thank you for rating this answer.

Visitor Comments

No visitor comments posted. Post a comment

Post a comment

To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Name:
   Email:
* Comment:
* Enter the code below:
 

Continue