Some general questions when importing lots of hands (25million hands).

[Eclipse86]

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?

[netsrak]

You should import it in portions of 1-2 millions but there is no need to vacuum / analyze during this process.

Vacuum/analyze only makes sense after purging data.