PokerTracker 4 uses the PostgreSQL database server to store your hand, in addition to information and various statistics about the hands you have played. All databases are extremely file intensive because data is constantly being written and read from your hard drive. Hard drives are very slow compared to the speed of all modern day computer processors, hard drives are therefore the number one cause of speed issues when accessing your data stored on the PostgreSQL Server with PokerTracker 4.
With proper configuration, PokerTracker 4 can minimize the number of times PostgreSQL is required to read from your hard drive by storing pieces of your database into Random Access Memory (RAM), this is much faster than the speed of your hard drive. By default, PostgreSQL is configured to use a very small amount of memory which is far from optimum. This tutorial will tweak the PostgreSQL configurations so that more memory is used by the database server and in turn PokerTracker 4's performance will be improved. This will affect all of your databases.
Tip: Hardware improvements usually result in the best possible database performance improvements, please consult the PokerTracker Recommended Hardware FAQ for additional information.
Database tuning is not availabe in the OS X version of PokerTracker 4 at this time.