Quote:
Originally Posted by lien
regarding the following 2 operations:
A. PT4 db housekeeping: rebuild cache + reindexing ... (if needed)
B. Windows drive (where PostgreSQL resides) defragmentation
what is the most appropriate order for performing (A,B or B,A) and why ?
(or it doesn't matter..)
If you are using Windows 7 you almost never need to defragment, skip this unless your having a problem, in fact you will find that startup times may be decreased for some time when you defragment due to the way that Windows caches key OS components on the hard drive to enable faster startup times.
PostgreSQL does its own equivalent of defragmenting the database when you perform a cache rebuild. Reindexing isn't necessary in PokerTracker 4, this is only needed after a purge of hands or when a database change has occurred, when that happens we automate this for you when the cache is rebuilt. We include Reindexing as a backup plan for our users, but it is almost never needed to be run by itself.
Of course this is a simple explanation of a complicated topic, if you have a more specific question let us know. You always ask such good questions, it is obvious you put some thought into your posts and want to learn as much as you can - good for you!
- TT