| From: | "Jan Theodore Galkowski" <bayesianlogic(at)acm(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | time penalties on triggers? |
| Date: | 2007-10-04 18:46:29 |
| Message-ID: | 1191523589.7753.1214187731@webmail.messagingengine.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Does anyone know, or can anyone point to information about how much
triggers penalize inserts in PG tables? I'm getting a report that it is
substantial, and before I investigate more. The triggers in question
look like:
#
# CREATE OR REPLACE FUNCTION touch_lasttouched() RETURNS TRIGGER AS
$touch_lasttouched$
# BEGIN
# NEW.lasttouched = NOW();
# RETURN NEW;
# END;
# $touch_lasttouched$ LANGUAGE plpgsql;
#
# DROP TRIGGER IF EXISTS trigger_touch_ams_faults_data ON
ams_faults_and_failures_data;
#
# CREATE TRIGGER trigger_touch_ams_faults_data
# BEFORE INSERT OR UPDATE
# ON ams_faults_and_failures_data
# FOR EACH ROW
# EXECUTE PROCEDURE touch_lasttouched();
#
Here the "lasttouched" column of a table is like:
#
# lasttouched TIMESTAMP(6)
#
and is intentionally left nullable.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Ginsburg | 2007-10-04 19:26:41 | Large Result and Memory Limit |
| Previous Message | Michael Glaesemann | 2007-10-04 18:04:25 | Re: good sql tutorial |