Re: Trigger functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: marc(dot)drouin(at)fondex(dot)ca
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger functions
Date: 2003-04-01 16:09:34
Message-ID: 1230.1049213374@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Drouin <marc(dot)drouin(at)fondex(dot)ca> writes:
> 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.

That's pretty slow, all right, but if you're not going to show us the
details there's not much advice we can offer.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-04-01 16:19:01 Re: Newsgroups/sites for SQL questions?
Previous Message Tom Lane 2003-04-01 15:57:44 Re: dropping a table with dependencies