Is tsvector_update_trigger() smart enough to not bother updating a
tsvector if the text in that column has not changed?
If not, can I make my own update trigger with something like
if new.description != old.description
return tsvector_update_trigger('fti_all', 'pg_catalog.english',
'title', 'keywords', 'description');
or do I need to do it from scratch?
I'm seeing very high cpu load on my database server and my current
theory is that some of the triggers may be causing it.
pgsql-performance by date
|Next:||From: Oleg Bartunov||Date: 2009-06-24 07:27:21|
|Subject: Re: tsvector_update_trigger performance?|
|Previous:||From: Chris St Denis||Date: 2009-06-24 07:16:38|
|Subject: Re: How would you store read/unread topic status?|