Postgres Pro
Downloads
Home   >   mailing lists

Re: very long update gin index troubles back? - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: very long update gin index troubles back?
Date
Msg-id 497F4851.3020106@sigaev.ru
Whole thread Raw
In response to Re: very long update gin index troubles back?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: very long update gin index troubles back?
List pgsql-general
Tree view 
> 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@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Text search with ispell
Next
From: Gabi Julien
Date:
Subject: New 8.4 hot standby feature