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