pog0
02-04-2010, 08:58 PM
I purged about 30 million hands which would probably be more than half of my DB (from purge hands option, NOT from observed HH options) and am now in the process of a manual vacuum (full + analyze). It's been going for about 24 hours now and my hard drive has the exact same amount of used space as when I started it.
Is this normal or is something going wrong?
**
Worth noting: at one point when I checked up on it I saw the final message in the log as:
ERROR: failed to re-find parent key in index "playerhandscashkeycolumns_idx1" for split pages 1434312/122363
**
At this point the option to hit OK was available (which it isn't now because I presume it's still working).
I have an 870,000 K process of postgres.exe running along with 10 other instances running at under 60,000 K each.
system: *quad core, 32bit xp, "4" GB ram.* I believe my DB is 170 GB.
Is this normal or is something going wrong?
**
Worth noting: at one point when I checked up on it I saw the final message in the log as:
ERROR: failed to re-find parent key in index "playerhandscashkeycolumns_idx1" for split pages 1434312/122363
**
At this point the option to hit OK was available (which it isn't now because I presume it's still working).
I have an 870,000 K process of postgres.exe running along with 10 other instances running at under 60,000 K each.
system: *quad core, 32bit xp, "4" GB ram.* I believe my DB is 170 GB.