"The Whole Nine Yards"?

"She had clowns, ponies--that kid's party went the whole nine yards." Is there some sport where nine yards is a lot of yards? If not, why is the whole nine yards used as an example of generous excess? One theory is that the phrase originally referred to the amount of fabric on an entire bolt of cloth. For a particularly elaborate garment, all nine yards of cloth would be used.