Re: Trigger functions - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger functions
Date
Msg-id 1230.1049213374@sss.pgh.pa.us
Whole thread Raw
In response to Trigger functions  (Marc Drouin <marc.drouin@fondex.ca>)
List pgsql-general
Marc Drouin <marc.drouin@fondex.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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: dropping a table with dependencies
Next
From: "scott.marlowe"
Date:
Subject: Re: Newsgroups/sites for SQL questions?