| From: | "Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com> |
|---|---|
| To: | "Pgsql General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | tsearch2 avoiding firing of triggers..... |
| Date: | 2004-12-16 22:21:22 |
| Message-ID: | 20041216222122.25759@mail.net-virtual.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
For some reason, I feel as though I have asked this before but I can't
find it anywhere..... I hope it is not repetitive!
I have various triggers and rules in my database, mostly for keeping
tsearch2 updated and (now) materialized views. I'd say probably 90% of
the updates to my database do not require these triggers/rules to fire
off, for example the materialized view trigger only needs to execute when
the category a record is in changes. The tsearch2 stuff, only when the
relevant data fields have changed.
Is there some way to either explicitly prevent the trigger/rules from
firing, or modify them in some way so that they only update when necessary?
Thanks!
- Greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Klint Gore | 2004-12-16 22:36:05 | Re: Non-aggregate values attached to aggregates? |
| Previous Message | Michael Fuhr | 2004-12-16 22:09:32 | Re: Non-aggregate values attached to aggregates? |