Re: very long update gin index troubles back?

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: very long update gin index troubles back?
Date: 2009-01-27 17:45:53
Message-ID: 497F4851.3020106@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> No matter if I drop the trigger that update agg content and the fact
> that I'm just updating d, postgresql will update the index?
Yes, due to MVCC. Update of row could produce new version (tuple) and new
version should be index as old one.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gabi Julien 2009-01-27 17:53:55 New 8.4 hot standby feature
Previous Message Gabi Julien 2009-01-27 17:33:20 Hot standby