Re: are there any method that "Update" command not affect other unrelated indices?

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: are there any method that "Update" command not affect other unrelated indices?
Date: 2010-10-13 15:23:49
Message-ID: AANLkTik0J1ZHOmvDf5hw-WoDdqoVZ+vsFp5fzJ6EeYu6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 13, 2010 at 10:31 AM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:
> All indices need to be updated, because Postgres does not do "upgrade in
> place", like some other databases do.
> When any column is updated, new version of the row created and the old
> one marked as deleted.
>

If you qualify for a HOT update the indexes do not need updating.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-10-13 15:36:34 Re: pitr question
Previous Message Geoffrey Myers 2010-10-13 15:17:40 pitr question