I do not know of a way to make your trigger run less often, but you could only
have it do the insert if something changes. This is what we do:
CREATE or replace FUNCTION UPDATE_SERVER_HST() RETURNS TRIGGER AS '
begin
if (OLD.ADD_DATE is distinct from NEW.ADD_DATE
or OLD.HOSTNAME
Hi,
I've the following problem and I don't know how to solve it: There is a
table with about 10-12 fields, a couple of those fields are updated very
often (about 30 times / minute or even more). This is my table (more or
less):
crete table monitor(
time Timestamp,
time2 timestamp,
.
