"Albe Laurenz" <all@xxxxxxxxxxxxxxxxx> writes: > Richard Broersma Jr wrote: >> My understanding is that Triggers offer better performance >> than rules do. > A trigger FOR EACH STATEMENT will execute the trigger function > for each row affacted by the statement. Huh? That would be true for a FOR EACH ROW trigger, but a STATEMENT trigger fires once per statement. > A rule would only > execute one additional statement. So if you can do it with a rule > conveniently, the rule will probably be faster. I find this unlikely. The overhead involved in setting up a rule is probably larger than that involved in calling a trigger. The real question is whether you need access to the modified data or not --- a statement-level trigger doesn't currently get that. regards, tom lane
