Re: insert/update tps slow with indices on table > 1M rows

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.