Re: very long update gin index troubles back?

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: very long update gin index troubles back?
Date: 2009-01-28 20:14:24
Message-ID: 20090128211424.5a2e85ba@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 27 Jan 2009 20:45:53 +0300
Teodor Sigaev <teodor(at)sigaev(dot)ru> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2009-01-28 20:38:47 Re: very long update gin index troubles back?
Previous Message Gabi Julien 2009-01-28 19:20:56 Re: Fwd: Re: New 8.4 hot standby feature