Re: FWD: Update touches unrelated indexes?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Jozsef Szalay <jszalay(at)storediq(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: FWD: Update touches unrelated indexes?
Date: 2006-06-30 17:27:49
Message-ID: 20060630172749.GA25181@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jozsef Szalay wrote:

> >he probably needs to think harder about whether every one of those
> >indexes is really carrying its weight.
>
> Unfortunately all of those indexes are required by the application. It
> appears that the only viable option I have is to drop the indexes and
> recreate them after the update.

Not at all -- the option is just continue to operate normally after the
update, because all the indexes are always updated. If you see an index
not being updated, it's a bug and by all means report it, preferably
with a test case other people can reproduce.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-30 17:58:35 Re: 100% CPU
Previous Message Joe Lester 2006-06-30 16:32:07 Re: Index Being Ignored?