From: Alvaro Herrera <alvherre@commandprompt.com>
To: Jozsef Szalay <jszalay@storediq.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: FWD: Update touches unrelated indexes?
Date: Fri, 30 Jun 2006 13:27:49 -0400
Message-ID: <20060630172749.GA25181@surnet.cl> (raw)
In-Reply-To: <E387E2E9622FDD408359F98BF183879E4D44C1@dc1.storediq.com>
References: <E387E2E9622FDD408359F98BF183879E4D44C1@dc1.storediq.com>
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.
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: alvherre@commandprompt.com, jszalay@storediq.com, tgl@sss.pgh.pa.us
Subject: Re: FWD: Update touches unrelated indexes?
In-Reply-To: <20060630172749.GA25181@surnet.cl>
* 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