Kbase 13568: How to estimate disk space needed for sorting by idxbuild
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/1/2007 |
|
Status: Verified
GOAL:
How to estimate disk space needed for sorting by idxbuild.
GOAL:
How to estimate the amount of disc space needed by idxbuild.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Use idxanalys by running the following:
proutil dbname -C idxanalys
This will show the total number of blocks in the database being used for indexes. The idxbuild with sorting will require the amount of blocks to be doubled then multiplied by the database blocksize.
This formula gives only estimate values. Some issues showed that the value given by idxanalys was not high enough. Because of compression we cannot get an exact number, e.g. a word index will usually compact a lot within the database, therefore its sort space will be proportionally much higher than a unique integer field that may not compact as much.
Conclusion: If you need to be on the safe side regarding required sort space:
a) use the values from past idxbuilds or
b) if this is not possible, reserve the approximate size of your current db for the sort space.