Re: tsvector_update_trigger performance?

Oleg Bartunov wrote:
> On Wed, 24 Jun 2009, Chris St Denis wrote:
>
>> Is tsvector_update_trigger() smart enough to not bother updating a
>> tsvector if the text in that column has not changed?
>
> no, you should do check yourself. There are several examples in mailing lists.

Or you could try using the supress_redundant_updates_trigger() function
that has been included in 8.4 (should be easy to backport)

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support