| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "andrew klassen" <aptklassen(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: insert/update tps slow with indices on table > 1M rows |
| Date: | 2008-06-04 06:02:34 |
| Message-ID: | dcc563d10806032302y47844ab3q2f3948c14ffec1b2@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Jun 3, 2008 at 4:36 PM, andrew klassen <aptklassen(at)yahoo(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Wakeling | 2008-06-04 10:31:22 | Re: insert/update tps slow with indices on table > 1M rows |
| Previous Message | andrew klassen | 2008-06-04 02:44:12 | Re: insert/update tps slow with indices on table > 1M rows |