omaha
02-24-2009, 03:47 AM
Hi, i have a huge dp on party, about 22million hands. When i first started, i got import speeds of 150ish, then recently, it was about 50h/s, which is still fine.
All of a sudden, it dropped to about 15h/s, not sure why.
I cant vaccum via hem, so i have done it via postgres.
I also purged about 4mill hands, then vaccumed via postgres, but no change in import speed.
I have postgres on a separate disk (nothing else is really on it). It is a 500gig drive, and only 84 gig are used.
I regularly defrag the drive that postgres is on.
Can anyone advise what i can do to improve my import speeds? Not sure why everything is super super slow at the moment!
All of a sudden, it dropped to about 15h/s, not sure why.
I cant vaccum via hem, so i have done it via postgres.
I also purged about 4mill hands, then vaccumed via postgres, but no change in import speed.
I have postgres on a separate disk (nothing else is really on it). It is a 500gig drive, and only 84 gig are used.
I regularly defrag the drive that postgres is on.
Can anyone advise what i can do to improve my import speeds? Not sure why everything is super super slow at the moment!