"Henry - Zen Search SA" <henry@xxxxxxxxx> writes: > On Fri, June 13, 2008 7:05 pm, Tom Lane wrote: >> The memory overhead per subtransaction is >> not zero, though I think it's fairly small if you don't have any >> triggers pending as a result of the insert. > Two triggers are fired for each insert (before and after trigs). The after trigger is probably the main source of the problem --- have you any way of avoiding that? (I wonder whether we can't improve on that, at least for the case of a non-deferred after trigger, which'd have already been fired before we exit the subtransaction. The trick is how to know that there's nothing useful left in the subtransaction's per-transaction memory context ...) regards, tom lane
