Re: tsvector_update_trigger performance?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Chris St Denis <lists(at)on-track(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: tsvector_update_trigger performance?
Date: 2009-06-24 16:29:15
Message-ID: 20090624162915.GB16227@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ibrahim Harrani 2009-06-24 17:32:14 cluster index on a table
Previous Message Robert Haas 2009-06-24 14:30:39 Re: Implications of having large number of users