3 ms·
There's no 8k limit with triggers? Could you expect on what you mean by that? One of the motivating factors for not using triggers is that the implied overhead
by anarazel 7y ago
There's no 8k limit with triggers? Could you expect on what you mean by that?
One of the motivating factors for not using triggers is that the implied overhead is very significant. By logging changes separately which triggers the write volume is roughly doubled, and the overhead of insertions is much much higher (a lot of fast/bulk path can't be used, the trigger processing needs to be performed).
- kiwicopple 7y agoSorry I meant I was using triggers to sent a NOTIFY which has an 8k byte limit. Very true what you mention about trigger overhead. Also you don’t get guaranteed atomicity