On Tue, Jun 3, 2008 at 4:36 PM, andrew klassen <aptklassen@xxxxxxxxx> wrote: > The cpu load is not that high, i.e. plenty of idle cpu. I am running an > older > version of freebsd and the iostat output is not very detailed. > During this time, the number is low < 10Mbs. The system has an > LSI Logic MegaRAID controller with 2 disks. > > Any ideas on how to find the bottleneck/decrease overhead of index usage. Older versions of BSD can be pretty pokey compared to the 6.x and 7.x branches. I seriously consider upgrading to 7 if possible. The cost of maintaining indexes is always an issue. There are a few things you can do to help out. Partitioning and having fewer indexes are what I'd recommend.
