Re: Re[2]: LISTEN/NOTIFY ultra slow speed

2022-03-15 Thread Tom Lane
=?UTF-8?B?0JDRgNGB0LXQvSDQkNGA0YPRgtGO0L3Rj9C9?= writes: > i looked at the file "\src\backend\commands\async.c" > there is a check for duplicate messages Yup. > Is this slowdown related to this check? [ shrug... ] You've provided no evidence either for or against that possibility. It seems a

Re[2]: LISTEN/NOTIFY ultra slow speed

2022-03-15 Thread Арсен Арутюнян
i looked at the file "\src\backend\commands\async.c" there is a check for duplicate messages   / PG 10 if (AsyncExistsPendingNotify(channel, payload)) return; ***/   / PG 13 if (AsyncExistsPendingNotify(n)) { …... } ***/ Is this slowdown related to this check? Is it