Re: LISTEN NOTIFY sometimes huge delay

"Peter Eser HEUFT [Germany]" writes: > I have a table with time series data and on this table a trigger for > notifies: > containers_notify AFTER INSERT ON containers FOR EACH ROW EXECUTE > PROCEDURE containers_notify('containers_notify_collector') > and the function does: > PERFORM pg_notify(CA

LISTEN NOTIFY sometimes huge delay

Hi all, I have a table with time series data and on this table a trigger for notifies: containers_notify AFTER INSERT ON containers FOR EACH ROW EXECUTE PROCEDURE containers_notify('containers_notify_collector') and the function does: PERFORM pg_notify(CAST(TG_ARGV[0] AS text), row_to_json