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.
> 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');
> return new;
> 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.
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
In response to
pgsql-performance by date
|Next:||From: Mathieu Nebra||Date: 2009-06-24 07:42:30|
|Subject: Re: How would you store read/unread topic status?|
|Previous:||From: Chris St Denis||Date: 2009-06-24 07:20:18|
|Subject: tsvector_update_trigger performance?|