Re: How to run a task continuously in the background

On Jul 17, 2019, at 1:26 AM, Dirk Mika <Dirk.Mika@mikatiming.de> wrote:

 

We used a trigger that called pg_notify (https://www.postgresql.org/docs/9.5/sql-notify.html​) and then had another

process that LISTENed for notifications.

 

What kind of process is this? I'm assuming that this is an application written in C.

 

The advantage of LISTEN / NOTIFY is only that the process which should process data does not have to do polling, but is notified when there is something to do.

 

Dirk

Also, the NOTIFY wouldn’t significantly extend the lifetime or impact of the trigger.

 

--  Dirk Mika Software Developer

<image001_d0a5cf51-5dd3-4ff5-b428-1016a6d95a0f.png> mika:timing GmbH Strundepark - Kürtener Str. 11b 51465 Bergisch Gladbach Germany

fon +49 2202 2401-1197  dirk.mika@mikatiming.de www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884  Geschäftsführer: Harald Mika, Jörg Mika

<CCh2U_f27a5ce6-8556-4db1-8aa4-fd610d6e9efe.jpg>