Eclipse86
10-05-2009, 07:44 AM
Hey guys,
So I just re-installed PostgreSQL and im looking to re-import all my hands. Have about 25 million hands or so to import from the last 4 months.
Questions are:
1. Is it okay to import all 25 million hands at once in one go, then vacuum/analyze? (I'm guessing would probably take me like 75 hrs to finish fully). Would I encounter any type of problems doing an import of that size?
2. Or, is it better to break it down to 5-10million hand chunks, and vacuum/analyze after each of those imports are done?
So I just re-installed PostgreSQL and im looking to re-import all my hands. Have about 25 million hands or so to import from the last 4 months.
Questions are:
1. Is it okay to import all 25 million hands at once in one go, then vacuum/analyze? (I'm guessing would probably take me like 75 hrs to finish fully). Would I encounter any type of problems doing an import of that size?
2. Or, is it better to break it down to 5-10million hand chunks, and vacuum/analyze after each of those imports are done?