From: Scott Marlowe <scott.marlowe@gmail.com>
To: andrew klassen <aptklassen@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: insert/update tps slow with indices on table > 1M rows
Date: Wed, 4 Jun 2008 00:02:34 -0600
Message-ID: <dcc563d10806032302y47844ab3q2f3948c14ffec1b2@mail.gmail.com> (raw)
In-Reply-To: <691681.3510.qm@web37304.mail.mud.yahoo.com>
References: <691681.3510.qm@web37304.mail.mud.yahoo.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, aptklassen@yahoo.com
Subject: Re: insert/update tps slow with indices on table > 1M rows
In-Reply-To: <dcc563d10806032302y47844ab3q2f3948c14ffec1b2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox