On Tue, Jun 3, 2008 at 4:36 PM, andrew klassen <aptklassen@yahoo.com> 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.