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.