PDA

View Full Version : normal DB size?



moomies
01-19-2010, 02:41 AM
i have about 250k hands of personal HH in my DB as well as 200nl-400nl FR/6m nlhe mined hands across 4 sites. all hands older than 2-3 months have been purged.

tbo i have no idea what my DB size should be, but when i checked postgres - 8.3 - data - base, the folder contain 334 GB of data. 1 of the 5 folders contained within the base folder contains all of the 334 Gb of data.

is this a normal DB size?

netsrak
01-19-2010, 07:38 AM
Not for 250 K hands.
i would roughly calculate with 10 GB for 1 Millon hands (not only your hands but all hands). http://www.holdemmanager.net/faq/afmviewfaq.aspx?topicid=23&faqid=19

Please check the performance tips from the link in my signature and you should also check if you have older databases which you can delete: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

And you can delete all the files in the pg_log subfolder of the postgres installation