Eclipse86
01-19-2009, 01:56 PM
So I just recently re-installed postgresql and recreated a 5-6 million hand db. I imported these hands in sets of 2 million, for each of those imports I maintained about an average of 60-80hands/sec.
After this was all done, I vacuumed full/analyzed manually.
I am now in the process of importing another 300k or so hands (first import after vacuuming/analyzing) and the speeds I am getting are only an avg of 33 hands/sec.
Is this normal?
Anything I can do to increase the import speeds?
After this was all done, I vacuumed full/analyzed manually.
I am now in the process of importing another 300k or so hands (first import after vacuuming/analyzing) and the speeds I am getting are only an avg of 33 hands/sec.
Is this normal?
Anything I can do to increase the import speeds?