PgQ and NOTIFY/LISTEN

Started by Олег Самойловabout 6 years ago2 messagesgeneral
Jump to latest

Hi all.

I looked for a forum or a mailing list for PgQ, but didn't find. May be someone know here?

Does PgQ use NOTIFY/LISTEN for PgQ internal daemon or consumers. And if not, why? May be it has internal own simulation of NOTIFY/LISTEN functionality?

#2Merlin Moncure
mmoncure@gmail.com
In reply to: Олег Самойлов (#1)
Re: PgQ and NOTIFY/LISTEN

On Wed, Jan 22, 2020 at 5:46 AM Олег Самойлов <splarv@ya.ru> wrote:

Hi all.

I looked for a forum or a mailing list for PgQ, but didn't find. May be someone know here?

Does PgQ use NOTIFY/LISTEN for PgQ internal daemon or consumers. And if not, why? May be it has internal own simulation of NOTIFY/LISTEN functionality?

For pgq questions. try the gthub page and raise an issue. Having said
that, looking at:

https://github.com/pgq/pgq/blob/master/functions/pgq.batch_event_sql.sql
and
https://github.com/pgq/pgq/blob/master/functions/pgq.ticker.sql

It's pretty clear that they are not using listen/notify, but some kind
of table/ticker based implementation. There used to be more
information on the implementation on the old skytools page, but that
page seems to have been retired.

merlin