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.