Postgres Pro
Downloads
Home   >   mailing lists

Re: tsvector_update_trigger performance? - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: tsvector_update_trigger performance?
Date
Msg-id 20090624162915.GB16227@alvh.no-ip.org
Whole thread Raw
In response to Re: tsvector_update_trigger performance?  (Oleg Bartunov <oleg@sai.msu.su>)
Responses Re: tsvector_update_trigger performance?  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Implications of having large number of users
Next
From: Ibrahim Harrani
Date:
Subject: cluster index on a table