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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
