| From: | Marc Drouin <marc(dot)drouin(at)fondex(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Trigger functions |
| Date: | 2003-04-01 15:12:17 |
| Message-ID: | F4DA80054BE0604A9E05C43B1CA905B202EA2C@serveur.fondex.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi group,
I managed to set up a trigger function and trigger in my database. At this
time its very rudimentary but I find that it seems to slow down the insert
procees quite a bit. I'm new to postgresql and database servers in general
so i'm not sure wheter this is normal or not.
The function is triggered on insert and is supposed to fill a field in the
table based on three other fields of the same table (ex: field D = Field A X
Field B X Field C). The addition of the trigger to teh table has slowed
down the insert procedd considerably. It takes approximatly two second for
a simple insert.
Can someone help me with that.
Like I said i'm new to all this so please be indulgent.
Marc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-01 15:15:27 | Re: lo_copy() |
| Previous Message | Peter Choe | 2003-04-01 14:36:28 | stored procedure |