On Wed, 2005-09-07 at 14:17, J wrote: > Hi, > I was wondering if there's a recommended maximum number of triggers in a > table? > Will having 3 triggers, one for insert or update, one for insert and one > for delete greatly impact performance?
It's not the number so much as what they're doing. If your trigger has some part causes a seq scan of a large table, then it will be slow. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
