pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Trigger overhead/performance and alternatives? 2+ messages / 2 participants [nested] [flat]
* Trigger overhead/performance and alternatives? @ 2018-07-01 09:31 AJG <ayden@gera.co.nz> 2018-07-07 07:47 ` Re: Trigger overhead/performance and alternatives? Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 0 siblings, 1 reply; 2+ messages in thread From: AJG @ 2018-07-01 09:31 UTC (permalink / raw) To: pgsql-performance Hello, Apologies if this is not in the correct forum for the non-urgent question that follows. I was reading the pgconf 2018 ppt slides by Jonathan Katz (from slide 110 onwards) http://www.pgcon.org/2018/schedule/attachments/480_realtime-application.pdf 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? 2) Is anybody aware of any other clever alternatives, pg extensions or github code etc as an alternative to using triggers? Thanks in advance, -- Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Trigger overhead/performance and alternatives? 2018-07-01 09:31 Trigger overhead/performance and alternatives? AJG <ayden@gera.co.nz> @ 2018-07-07 07:47 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2018-07-07 07:47 UTC (permalink / raw) To: AJG <ayden@gera.co.nz>; pgsql-performance 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-07-07 07:47 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2018-07-01 09:31 Trigger overhead/performance and alternatives? AJG <ayden@gera.co.nz> 2018-07-07 07:47 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox