On Tue, 27 Jan 2009 20:45:53 +0300 Teodor Sigaev <teodor@xxxxxxxxx> wrote: > > 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. Does that mean that it could be a good choice to place the tsvector in another table? thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
