Postgres Pro
Downloads
Home   >   mailing lists

Re: are there any method that "Update" command not affect other unrelated indices? - Mailing list pgsql-general

From Vick Khera
Subject Re: are there any method that "Update" command not affect other unrelated indices?
Date
Msg-id AANLkTik0J1ZHOmvDf5hw-WoDdqoVZ+vsFp5fzJ6EeYu6@mail.gmail.com
Whole thread Raw
In response to Re: are there any method that "Update" command not affect other unrelated indices?  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-general
Tree view 
On Wed, Oct 13, 2010 at 10:31 AM, Igor Neyman <ineyman@perceptron.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.

pgsql-general by date:

Previous
From: Geoffrey Myers
Date:
Subject: pitr question
Next
From: Vick Khera
Date:
Subject: Re: pitr question