Re: very long update gin index troubles back?

[Teodor Sigaev <teodor@xxxxxxxxx>]

> 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@xxxxxxxxx
                                                   WWW: http://www.sigaev.ru/

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general