Re: tsvector_update_trigger performance?

От: Alvaro Herrera
Тема: Re: tsvector_update_trigger performance?
Дата: ,
Msg-id: 20090624162915.GB16227@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: tsvector_update_trigger performance?  (Oleg Bartunov)
Ответы: Re: tsvector_update_trigger performance?  (Dimitri Fontaine)
Список: pgsql-performance

Скрыть дерево обсуждения

tsvector_update_trigger performance?  (Chris St Denis, )
 Re: tsvector_update_trigger performance?  (Oleg Bartunov, )
  Re: tsvector_update_trigger performance?  (Alvaro Herrera, )
   Re: tsvector_update_trigger performance?  (Dimitri Fontaine, )
    Re: tsvector_update_trigger performance?  (Chris St Denis, )
     Re: tsvector_update_trigger performance?  (Craig Ringer, )
      Re: tsvector_update_trigger performance?  (Dimitri Fontaine, )

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 по дате сообщения:

От: Dimitri Fontaine
Дата:
Сообщение: Re: tsvector_update_trigger performance?
От: Chris St Denis
Дата:
Сообщение: Re: tsvector_update_trigger performance?