Speaking of triggers...

Is there any plan to speed up plpgsql tiggers?  Fairly simple
crosstable insert triggers seem to slow my inserts to a crawl.

Is the best thing just to write triggers in C (I really don't want to
put this stuff in the application logic because it really doesn't
belong there).

Alex Turner
netEconomist

On Apr 12, 2005 10:10 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> hubert lubaczewski <[EMAIL PROTECTED]> writes:
> > and it made me wonder - is there a way to tell how much time of backend
> > was spent on triggers, index updates and so on?
> 
> In CVS tip, EXPLAIN ANALYZE will break out the time spent in each
> trigger.  This is not in any released version, but if you're desperate
> you could load up a play server with your data and test.
> 
>                         regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to