Environment variables for large index rebuilds
Barry Wiseman
bwiseman at optonline.net
Thu Apr 24 08:52:37 PDT 2008
This weekend I will be rebuilding all indexes in a large system. These
folks have long been in the habit of laying time bombs for themselves by
rebuilding indexes on a non-idle system (don't ask!).
Hundreds of these indexes are large (>10Mb), many dozens are quite large
(>100Mb, with record sizes ~4K and file sizes ~1M records). They are
mostly post-4.5, multi-key indexes.
This is a SunOS system, I don't know what the hardware is but it's no
great speed demon. The customer has scheduled 24 hours of downtime for
me this weekend, and I'm concerned it may not be enough.
Reading the online manual, I see there are several variables I'm not
familiar with. As usual, the descriptions shed not much light. Which
of the following will be my friend on this project? I'm sure the
tweaking of dxmaint in this manner is very much a black art, but any
guidelines on useful values will be much appreciated.
PFBIXBUILD
PFBIXNODESIZE
PFMAXTEMP
PFMAXTFIL
PFNUMIXBUILD
More information about the Filepro-list
mailing list