On 01.07.18 11:31, AJG wrote: > Where is mentioned trigger overhead, and provided an alternative solution > (logical replication slot monitoring). > > My 2 part question is. > > 1) Does anybody have any benchmarks re: trigger overhead/performance or have > any experience to give a sort of indication, at all?
That really depends on a lot of things, how you write the triggers, what they do, etc. You should probably measure that yourself. > 2) Is anybody aware of any other clever alternatives, pg extensions or > github code etc as an alternative to using triggers? Maybe wal2json will give you a starting point. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
