Thread: max number of triggers in a table

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?

Thanks,

J

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.