PDA

View Full Version : Import Speeds drastically decreasing after the first vacuum/analyze



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?

morny
01-19-2009, 02:52 PM
As the databases increase and the indexes increase the speed will decrease. Different sites and different gametypes import at different speeds. Vacuuming helps with lagging and hud refreshing speeds but doing a defrag is more beneficial with import speeds so you can try that