Re: pg_notify contention

2024-04-30 Thread Dimitris Zenios
uot;txn_commit": $x.timestamp, > "transactional": $x.transactional > }' > > Note, this is not a 100% replacement. The semantics are slightly > different. You also need a replication slot which comes with its own > maintenance cost. But maybe it's w

pg_notify contention

2024-04-30 Thread Dimitris Zenios
Hi, I am measuring a very simple case of pg_notify in an after update trigger. The trigger is the following: CREATE OR REPLACE FUNCTION audit_event() RETURNS TRIGGER AS $$ BEGIN PERFORM pg_notify('user', 'hello world'); RETURN NULL; END; $$ LANGUAGE plpgsql; and configured on