Resuming this discussion in a new thread to focus only on this question:
What is the best way to get the size of an index so it does not get too
big to be optimized (or to allow a very large segment merge) given space
limits?
I already have the largest 15,000rpm SCSI direct attached storage so
buying storage is not an option. I don't do deletes.
From what I've read, I expect no more than a 2x increase during
optimization and have not seen more in practice.
I'm thinking: stop indexing, commit, do a du.
Will this give me the number I need for what I'm trying to do? Is there
a better way?
Phil